Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
BYENER
Helper V
Helper V

Refresh last X days Power BI desktop

Hi All,

 

I refresh my report in Power BI desktop by using the refresh button. Is there a way to refresh only the last X days and keep the older data also in the report.

 

Thanks in advance.

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

@BYENER ,

 

I'm afraid this couldn't be achieved in power bi. The dataset in power bi desktop will be replaced with data source when you click refresh button. I would suggest you create a stored precedure to save the old data in database.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-yuta-msft
Community Support
Community Support

@BYENER ,

 

I'm afraid this couldn't be achieved in power bi. The dataset in power bi desktop will be replaced with data source when you click refresh button. I would suggest you create a stored precedure to save the old data in database.

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Why Power bi is so dumb compared to Tableau , there is no option to refresh monthly or custom date. 

Its very simple to introduce , what the heck Microsoft 

Greg_Deckler
Super User
Super User

Would need to use incremental refresh.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

I did it, first the parameters then the custom filtered and latest the incremental refresh setting. When I push the refresh button the whole dataset is refreshing again.

 

Parameter:

StartRange (01.01.2019)

EndRange (31.12.2020)

 

Incremental refresh settings:

Store rows in the last 2 years

Refresh rows is in the last 7 days.

 

Expected result: refreshing the last 7 days and keep the last 2 years data in the query. I want to see the last 2 years data in the report view.

 

 

I'm having the same issue, have you find the solution?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.