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
PshemekFLK
Helper IV
Helper IV

Replace the dataset only once it's refreshed in service

I have a published report that is updated daily automatically with the new data.

 

Last time I made changes to the model/measures was few days ago so my pbix version is missing few days of data. I can't refresh it in PBI desktop due to memory issues. I can only refresh in service.

 

How can I republish my report without overwriting with dataset that's few days old. The refresh in service takes 15 min so during this 15 min users will see incomplete data. How can I avoid this?

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @PshemekFLK 

 

You could look at using Incremental refreshing and the XMLA end point if you are using Power BI Premium or Premium Per User?

 

Or you could publish it at a time when there is not a lot of usage on the Power BI report?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

4 REPLIES 4
GilbertQ
Super User
Super User

Hi @PshemekFLK 

 

You could look at using Incremental refreshing and the XMLA end point if you are using Power BI Premium or Premium Per User?

 

Or you could publish it at a time when there is not a lot of usage on the Power BI report?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

For anyone looking for the solution XLMA endpoint is indeed the way to go using ALM toolkit (free add-on to Power BI). You can learn more here: 

Deploy Power BI dataset schema changes WITHOUT refreshing! - YouTube

@GilbertQ ,

I'm already using incremental refresh but it only helps with reducing the refresh time in the service. In Power BI desktop I need to refresh the complete data hence the memory issue. Publishing it at a time when there is not a lot of usage is also not an option as report is heavily used in different time zones. How can I use XMLA end point in this case?

Hi @PshemekFLK 

 

With the XMLA end point you can just deploy the changes to your Incremental refresh policy. When doing this you will not have to reload all the data. It will update the partition refresh policy.

 

Upon the next refresh it would then process and add in the new partitions based on your settings.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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.