Leveraging incremental refresh and folding
When you load data from Power Query, you do not perform a one-time load, but usually, you need to refresh data in order to load new data or to update existing data. When loading data incrementally, it is possible to leverage parameters and query folding in order to optimize and retrieve data quickly. In this recipe, we will see how to set up time parameters and incremental refresh.
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 click on More… to access the Get Data window and to see the complete list of connectors.
Figure 6.46 – Power BI connectors
- Browse to the Azure SQL database connector, select it, and click on Connect.
Figure 6.47 – Azure SQL database...
