incremental refresh is not working properly

[Anonymous]

Hello Team,

I have configured the incremental refresh, rangestart: 1st jan 2020 rangeend:31 dec 2021

turned on the incremental refresh for specific table and store rows last 1 year, refresh rows last 1 month. 

when i update some values at table in db then feb month data is updating and showing the values correctly

when i update the modified date for feb its not showing on the reports after dataset refresh successfully.

my power bi file is getting query folding error like below

any idea?

[v-kelly-msft]

Hi  @Anonymous ,

When the required query folding cannot take place,you will get the above error notification.

Check the reference below:

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#query-folding

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!