incremental refresh

[powerbiexpert22]

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 

[rajendraongole1 · Accepted solution]

Hi @powerbiexpert22 - You can leverage incremental refresh when combining files, please check out the below links.

Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft...

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!!

[amitchandak]

@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

https://www.youtube.com/watch?v=qZOEDBedATA