Incremental Refresh In Power BI

[govind_08]

I have one question regarding incremental refresh in Power bi
my data set it from data verse url and from power automate flow
and using these two source i am appending two queries and making on master table so my question is i want to apply incremnatal refresh policy on this table and also as these sources do not support query folding so will i be able to set a policy or not.

[Thomaslleblanc]

I would stage the data into 2 tables in a Lakehouse and use the UpdateDate from the dataverse data. Then, combined the 2 tables together based on defined join and use the combined table for Incremental refresh in Power BI

[cengizhanarslan]

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

[FBergamaschi]

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