cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mer-Petti
Helper I
Helper I

PowerBI.RefreshDataset RunTime Error

I have been using the Power BI setting inside of my PowerApps without issue.

 

However today my users are getting a "Throttle" error. 

MerPetti_0-1652208724279.png

 

The code has not changed within the Application or the PBIX file.  However, when I check the PBIX is is refreshed. Is this a bug?

 

Any guidance is greatly appreciated.

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Yes that solution would work as long as it doesn't conflict with other refreshes. I am not sure how many times at once your users use it but I have created flows that will refresh and I put in a do until success those have not had an issue with.

View solution in original post

3 REPLIES 3
Crullgl
Helper I
Helper I

Normally this happens when you have multiple datasets refreshing around the same time.  I recommend looking at schedules to see if you can stager them based on how long it takes if you have a lot.  You could also build a flow to autom refresh which gives you a little more flexability then the built in refresh in settings for your dataset. 

 

Refresh operation throttled by Power BI Premium

A Premium capacity may throttle data refresh operations when too many datasets are being processed concurrently. Throttling can occur in Power BI Premium capacities, or more rarely, in Premium Gen2 capacities. When a refresh operation is canceled the follow error message is logged into the refresh history:

The operation was throttled by Power BI Premium because there were too many datasets being processed concurrently.

If the error occurs frequently, use the schedule view to determine whether the scheduled refresh events are properly spaced. To understand the maximum number of concurrent refreshes allowed per SKU, review the table at the bottom of the Premium limitations section.

To resolve this error, you can modify your refresh schedule to perform the refresh operation when fewer datasets are being processed, increase the time between refresh operations for all datasets in your refresh schedule on the affected Premium capacity, or do both. You can retry the operation if you're using custom XMLA operations.

 

Here is link to those errors Troubleshooting refresh scenarios - Power BI | Microsoft Docs

 

Hope that helps

Mer-Petti
Helper I
Helper I

The problem is multiple users. If I set the refresh from Power Apps and I have multiple users that are submitting updates it's getting bottlenecked. I'm opting to remove this function from my application and instead using Power Automate to push a refresh once every 2 hours on offsetting time intervals. 

Yes that solution would work as long as it doesn't conflict with other refreshes. I am not sure how many times at once your users use it but I have created flows that will refresh and I put in a do until success those have not had an issue with.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (2,786)