Load Previous 365 Days data and refresh only previous 30 days of data

[goureshgundami1]

Hi Community,

Requirement 1st :-

I have fact table with 10 years of data and I want load previous 365 days data into Power BI.

Requirement 2nd :-

After loading previous 365 days data  I want to refresh only previous 30 days of data incrementally. It means remaining previous 11 months data will remain static while refreshing 30 days of data.

Could anyone please help me out to reach my requirement.

Thanks in Advance!

[amitchandak]

@goureshgundami1 , You can setup incremental load with that frequency

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

Power BI Incremental Refresh Pro; Premium Deployment pipeline - https://youtu.be/nIxTRdeCYSE