March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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.
Solved! Go to Solution.
@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.
@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
Would need to use incremental refresh.
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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
94 | |
89 | |
86 | |
77 | |
49 |
User | Count |
---|---|
164 | |
149 | |
101 | |
73 | |
56 |