Forum Discussion

cassidy's avatar
cassidy
Power Participant
2 years ago

Poor Refresh Performance only in Service

We've had several semantic models go from < 5 minute refreshes to > 1 hour in the last 3 days.   I've tested various things, but it boiled down to an unexplainable result:   I can publish an exac...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,  cassidy 

Based on your description and the tests that have been conducted, I think refresh time delays may occur for the following reasons:
1. Extensive use of dashboard tiles or advanced caching may increase refresh duration, as both operations queue many queries after each refresh.

2. Complex queries and data loading may lead to extended refresh time.

3. Use dynamic data source definitions and costly DAX calculations. In particular, avoid using DAX functions that test every row in the table, as the memory consumption and processing overhead of such functions are very high.

4. Resource limitations. In Power BI Service, data refresh resources may be limited based on system load. If your semantic model is refreshed during periods of high system load, you may experience reduced frequency.

You can follow the following points to troubleshoot and improve the refresh performance of your semantic model:

 

 

Related document links: Data refresh in Power BI - Power BI | Microsoft Learn

 

 

 

 

How to Get Your Question Answered Quickly

Best Regards

Jianpeng Li

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

 

cassidy's avatar
cassidy
Power Participant
2 years ago

Hi Anonymous , as I and other users have posted, this is not related to best practices or current capacity load. 

An EXACT copy of the same model can be published to the same or different workspace and the model will refresh perfectly fine. The only difference is the duplicated model has a different Id.

  • dp410's avatar
    dp410
    Advocate II
    2 years ago

    We tested putting the dataset into another workspace yesterday and that worked. I've created a new workspace today for production and the issue is occuring again. 

  • cedar's avatar
    cedar
    Frequent Visitor
    2 years ago

    cassidy dp410 I'm wondering which PBI capacity region you are in. I'm experiencing the issues in Australia East.

    • dp410's avatar
      dp410
      Advocate II
      2 years ago

      We are experiencing issues in UK South.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, cassidy 

    Have you checked your Refresh history  and Refresh summary in the Admin portal? In these two places, you can see which part takes longer to refresh. If you urgently need to solve the current problem, you can click the link below to open a ticket so that specialized personnel can follow up and solve your current problem.

    Pro license raise a ticket: https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

    Post an issue: https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues

     

     

    How to Get Your Question Answered Quickly

    Best Regards

    Jianpeng Li

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