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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors