Fixing Query Folding with SQL Server in Power BI for Incremental Refresh
The pitfalls of using Native Database Queries to import data from SQL Server
This article is also available at bits 2 BI
Incremental refresh on the Power BI datasets has three significant benefits; faster refreshes, more reliable refreshes, and reduced resource consumption. Incremental refresh is designed for data sources that support query folding. This might give an impression that the query will fold regardless of how the data transformation has been set up.
This assumption, however, is far from the fact: transformation steps need to be implemented appropriately to ensure query folding. When troubleshooting, transformation steps are the usual suspects that developers look at. Nevertheless, one of the foremost reasons is using native SQL queries to import the data.
This article looks at how to fix query folding to set up incremental refresh when a native database query is involved in importing the data from the SQL Server.
Please read our terms of use before proceeding with this article: https://dhyanintech.medium.com/disclaimer-disclosure-terms-of-use-fb3bfbd1e0e5
Query folding is Power Query's ability to generate a single query expression to…
