Tag Archives: sql

  • Lazy Evaluation & Query Folding in Power BI / Power Query

    image

    How do things work in the world? Humans are curious beings.

    We want to know how things work and perhaps harness them for our own purposes.

    In this case, we’re curious about how the Evaluation Model works for Power BI & Power Query when it comes to executing your queries and getting your data.

    You can read the official documentation from the Microsoft team here, but in this post I’ll cover the basics, so you can have a quick overview of how things work with Power Query / Power BI and how you can optimize your queries to better harness their engine.