Incremental Refresh Error

Hi everyone, Incremental refresh stops working when I changed the data type of another column. These are my applied steps. I made no changes to the datetime column used for filtering. I ...

Need Help

rajendraongole1

Super User

2 years ago

Hi rdini8 - Incremental refresh relies heavily on query folding. If the data type change step breaks query folding, incremental refresh might not work correctly.To verify query folding, right-click on each step in the Power Query Editor and check if "View Native Query" is available. If it is not available after the data type change step, query folding is broken.

Reference link:

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

How to Implement Incremental Refresh in Power BI | phData

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!