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
amallen125
Frequent Visitor

Data refresh suddenly slow in BI Service

I've got a fairly basic PBI dataset; source data is imported not live connected, source is several small excel files in SharePoint, pretty straight forward queries.  Our company has premium.  In the past it would consistently refresh in about 5 minutes in the service and a little longer in desktop.  Starting yesterday (February 23 2024) the published/service refreshes are taking several hours, the shortest was 30 minutes, but those are rare.  I pulled down the PBIX, and refreshed in desktop, and it takes 9 minutes, which is excepted becaue by local RAM isn't great.

 

I'm at a loss.  Other reports don't seem to be impacted.  Nothing has changed in the import or the source files.  Although I'm sure I could tune my queries, it seems like the BI service is the problem.

 

Please share any ideas or insights.  Thanks,

1 ACCEPTED SOLUTION
amallen125
Frequent Visitor

I ended up publishing the same PBIX to a non premium workspace and saw a refresh time of 5 minutes.  This confirmed some sort of premium throttling.  The metrics didn't show any indication of system stress.  I ended up turning off the refresh schedule (luckily it was the weekend).  1.5 days later and it worked fine, no model changes, no source data changes.  bizarre stuff.  Thanks for everyone's input on this.

View solution in original post

6 REPLIES 6
amallen125
Frequent Visitor

I ended up publishing the same PBIX to a non premium workspace and saw a refresh time of 5 minutes.  This confirmed some sort of premium throttling.  The metrics didn't show any indication of system stress.  I ended up turning off the refresh schedule (luckily it was the weekend).  1.5 days later and it worked fine, no model changes, no source data changes.  bizarre stuff.  Thanks for everyone's input on this.

Ohhh you're probably just out of resources. In premium, you only have a set amount of resources to use based on the pricing scale. 

christinepayton
Super User
Super User

Are you using the SP Folder connector, or connecting to a specific file? The folder connector performance can vary quite a bit depending on how much content is in the site, so if someone uploaded a bunch of files elsewhere it could slow down your query depending on how it was set up. 

 

SharePoint will also throttle you if you try to make too many queries, which I THINK is on a per-user basis, so if you are doing a lot of other work on SharePoint sources elsewhere with the same user account you could be getting throttled. There's a thread here with workarounds for throttling:

https://community.fabric.microsoft.com/t5/Service/Avoid-throttling-when-loading-from-SharePoint-fold...

I can confirm that Binary.Buffer on SharePoint documents does help with the process. Not only does it seem to be faster, it also reduces the chattiness and largely avoids getting nasty 429's

aj1973
Community Champion
Community Champion

Hi @amallen125 

In premium capacity you can always find an explanation to what caused your issue. If you have access to the Premium Metrics App then follow this video to understand

Making sense of the Power BI Premium Gen2 Metrics App (youtube.com))

 

Understand the metrics app compute page - Microsoft Fabric | Microsoft Learn

 

If you don't have access then The Admin of the tenant should be able to explain it to you.

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

lbendlin
Super User
Super User

Since you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

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