Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.