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.
Hi,
I have setup incremental refresh and It seemed to be working fine, there was no errors and data looked correctly. But after a while one of the user reported that data for last few days are incorrect - some are higher, some are lower than expected. I already eliminated an error with "=" sign on both Range end and range start.
My incremental refresh looks like this:
1. filtered columns in fact tables has datetime type
2. Archived are last 36 months
3. refreshed are last 30 days
I still got worning that "unable to confirm if the M query can be folded" but I suppose it is only related to refresh time and it is not required that query must be folded.
Thanks in advance for your help!
HI @ryszardre,
Thanks for your sharing, I think this type of informations may help others who faced the similar scenario.
Regards,
Xiaoxin Sheng
It turns out that issue is more complicated - I raised a ticket to MS support and for now I got instruction that if native query in power query is inactive (grayed-out) it is then more complicated to implement Incremental Refresh. I will write more when I have more info.
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.