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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
syedshah01
Regular Visitor

power automate data refresh goes into waiting state

In Power Bi report, I connected to a power automate workflow to let the users trigger the data refresh from within Power BI.

 

The problem is that sometimes the data refresh completes successfully and sometiems it goes into waiting status and then eventually throws an error

syedshah01_0-1721125426011.png

I failed to understand how did I hit the limit. I have a power bi premium per capacity license and I should be able to run the workflow atleast 48 times a day. I only triggered it second time and it threw this error.

 

What should i do to fix this? below is the run history. yesterday, I thought i am pressing it too quickly but today i hit the next run a few mintues afterwards. The refresh itself takes only a few seconds to complete when it runs successfullly

syedshah01_1-1721125515185.png

 

1 REPLY 1
GilbertQ
Super User
Super User

Hi @syedshah01 

 

It appears to me that you are refreshing the data sets too often and the previous data set refresh has not completed and that is.  why they're starting to throttle you because of the refreshes coming through while they are existing refreshes happening. I would suggest first checking to see if the refresh is being run and if so wait until it is completed to then start to next refresh.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors