Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Thanks,
Nishanth.
Hi @Anonymous ,
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.
Best Regards,
Xue
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Xue,
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...
Thanks,
Nishanth.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
96 | |
78 | |
68 | |
55 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |