Forum Discussion
Incremental refresh - not working?
Hello, I am implementing an incremental refresh for one of my reports. Here are the steps I did - 1. Created parameters for RangeStart and RangeEnd with their values as 6/1/2020 and 12/31/2020 (th...
I am using Import.
Below is my query which does indicate the query folding happening
However, in the configuration, it says it is unable to confirm if Query folding is happening or not, so that is weird.
Regards
Hi Anonymous ,
- If your data source coming from a data source that supports query folding, then Incremental load works as it best. If not, it is not recommended to use it. Most of the time, a huge data source is coming from a relational data store system, which supports query folding by the way. Refer: All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only
- If the PBIX file was authored in a version of Power BI Desktop prior to the 2019 February release, the warning will be displayed regardless until a data refresh is performed. Refer: Incremental refresh & query folding
- Please check if there's filter logic in your query. It's recommended that verification is performed to ensure the filter logic is included in the source queries. To make this easier, Power BI Desktop attempts to perform this verification for you. If unable to verify, a warning is displayed in the incremental refresh dialog when defining the incremental refresh policy. SQL based data sources such as SQL, Oracle, and Teradata can rely on this warning. Other data sources may be unable to verify without tracing queries. If Power BI Desktop is unable to confirm, the warning is displayed.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your comments
My source is Azure SQL and in Power Query, I can see "Native Query" enabled, so not sure why Query folding does not happen.
Any reason why it is still not working?
Regards