I have setup incremental refresh. But i don't think it is really working.
My data contains data from 2018 and 2019. My default parameters
RangeStart = 2018-01-01 00:00:00:000
RangeEnd = 2019-12-31 00:00:00:000
My policy : Store rows in last 1 years and refresh in last 2 months
However, after i publish i still see the data from RangeStart and RangeEnd.
I've seen few blogs that QueryFolding is mandatory for incremental refresh is it true?
My Source is Azure SQL, Query folding is available for first 5 steps and few transformations after that broke the Quey folding? Is this an issue?
Hi @NishanthV ,
For incremental refresh, the data source must support “query folding” which is supported by most data sources that support SQL databases.
There are the blogs you can reference.
Important Considerations for Setting up Incremental Refresh on Power BI Desktop
Please create a sample to test again. If it still doesn't work, you could create a ticket to get timely help.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the Reply. I tried this, however i am still not able to see that it is working.
Data is still loading from what i have given as the Range Start.
Not sure what am i missing here...
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.