Forum Discussion
Incremental Refresh In Power BI
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.
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
-
5 Replies
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
-
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
Hi govind_08
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.Hi govind_08
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
