Incremental Refresh In Power BI

Hi govind_08 

you can but the table maust have a date/time column

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

You can configure incremental refresh in this setup, but it will not work the way you probably expect, because query folding is a key requirement. Since you do not have folding here Power BI will fall back to full refresh every time even it only refreshed to configured Start and End date et the end of the process.

Land both sources into:

• Dataverse tables (if possible), or

• SQL / Lakehouse / Warehouse

Then:

• Apply incremental refresh on that single foldable source

• Append and transform upstream, not in Power BI