Forum Discussion
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 exact copy of the model to the same workspace and it will refresh as normal, even while the original is spinning for an hour. This alone seems to prove all connections and data sources within the model are fine. In Desktop, works as normal, including the original.
Why does creating a new model Id fix it? How can I make orignal model to perform the same as the copy?
20 Replies
Hi, I have the same issue but worse. Our report on Power BI service takes more than 18 hours to refresh and then fails due to a timeout issue. I've published it to another workspace and it took only 2 minutes to refresh the report in the new WS. I've tried everything, including changing the owner, upgrading the gateway, etc.
My WS is on premium capacity
I am having similar issue. The issue started happening since Friday. Over the weekend the data model was refreshing without any issue but suddenly today morning same issues.
Is there any fix or know if microsoft is having a issue?
Thank you abdulquadirshai and cedar , now that I know it's not just me I've submitted an Idea
Please vote and add your comments
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=7a668985-0ad5-ee11-92bd-000d3a7ac590I too am experiencing the exact same issue. I have our main enteprise semantic model that has refreshed consistently without issues for the past 18 months at an average time of 10 minutes within Power BI service. However, starting about the same time as your issues it is taking anywhere from 45 minutes to not completing. Locally refresh time is about 2 minutes. This issue is driving me crazy can MSFT look into this?
Me too!
Exactly the same - one refresh went from 40 minutes to 6 hours for no reason at all
Hi, cassidy
This issue has been confirmed as a known issue internally. Please be patient to wait for fixing. If there is any news, I will update it here.
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.
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.
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.
Hello everyone, I've experience the same situation here. Any thoughts?
I last heard from our microsoft support engineer at noon GMT. Apparently this is affecting many users and he's waiting to hear back from the engineering team for an update.
All of the issues stopped for me. I had a support call on Tuesday and when we tested it live I could not replicate. All 50+ of my models have been refreshing weirdly faster than ever.
I asked support to still reply back to confirm it was solved and not a fluke, have not heard back.
Similar isue hppening to me now. Where after a few hours the connection times out and the model fails to refresh
