Incremental refresh - incorect data for only last few days, no error message

[ryszardre]

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!

[v-shex-msft]

HI @ryszardre,

Thanks for your sharing, I think this type of informations may help others who faced the similar scenario.

Regards,

Xiaoxin Sheng

[ryszardre]

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.