How to dynamically import data based on last two years - Date ID

[CuriousKoala]

My organization uses a SQL data warehouse and uses direct import into Power BI. We have date IDs in our Date dimension table. For instance, 6300 is March 31st, 2025. Our fact tables are getting larger, exceeding 5 million rows and growing by the day. 

Is there a way for me to set up our import to only pull in the last two years of data? So today is April 1st, 2025. Power BI would import April 1st, 2023 through today. Then tomorrow, it would import April 2nd, 2023 through today, and so on. I have had trouble figuring out an automated solution to this. As of now, we have to filter the power query editor to only pull in 2023 through present, but the organization will be faced with the same issue as the months and years go on, of our fact tables getting larger and our imports slowing down. Is there a way to use parameters, filters, or something else to achieve our goal of only importing the last two years of data and nothing more?

Thank you!

[v-achippa]

Hi @CuriousKoala,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Deku for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user's resolved your issue? or let us know if you need any further assistance.
If our super user's response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @CuriousKoala,

We wanted to kindly follow up to check if the solution provided by the super user's resolved your issue.

If our super user's response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @CuriousKoala,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user's resolved your issue.
If our super user's response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Deku · Accepted solution]

If you use incremental refresh you can set a range of data to be imported, within this range you can specify what data is not refreshed but is kept in the model, with only the most recent data being imported, but with older data still being accessible to the report