Folding queries
You often connect to relational sources, and it is important to know how to leverage query folding in order to retrieve data from the sources with Power Query steps that act as a single query statement. Query folding helps us to push more steps toward the origin data source in order to reduce the number of steps processed by the Power Query engine.
In this recipe, you will see how to perform query folding and how to control it.
Getting ready
In this recipe, you need to connect to an Azure SQL database that you can recreate in your environment with the Adventureworks.bacpac file.
How to do it…
Once you open your Power BI Desktop application, you are ready to perform the following steps:
- Click on Get data and then More… to access the Get Data window and see the complete list of connectors.
Figure 6.35 – Power BI connectors
- Browse to the Azure SQL database connector, select it, and click on Connect.
Figure 6.36 – Azure...
