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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors