Forum Discussion
incremental refresh
i need to know how to set up incremental refresh by appending queries , fact table has data for 2022, 2023 and 2024 years as per below with 19 rows (sample data)
I have created three separate queries to load data for each year as shown below
data is inserted or updated for last 2 weeks
Hi powerbiexpert22 - You can leverage incremental refresh when combining files, please check out the below links.
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
2 Replies
Hi powerbiexpert22 - You can leverage incremental refresh when combining files, please check out the below links.
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
Hope it helps
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!powerbiexpert22 , Setup incremental for only 2024.
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
Power BI Incremental Refresh Pro; Premium Deployment pipeline - https://youtu.be/nIxTRdeCYSE
I think you could have done with one table too. And Loaded full data only in the service
The way suggested by Guyinacube
