Power Automation flow error to Refresh the Power BI dataset

[randika118]

Hi,

i use Power Automation to trigger and refresh the dashbaord every two minutes. During the last few months, it worked properly but from yesterday onwards, the flow is not running but it runs only 8 times per day as i checked (i am using PowerBI Pro version). This is the error message in Power Auromation.

"Request is blocked by the upstream service.
Looks like your flow's operation is hitting an action limit designed to protect the connector service being called.
Error
Alert: Your operation has been throttled."

can you help me solve this issue? Is this with pro version capacity?

Thanks

[christinepayton]

If you need your data updated every two minutes, you should be using direct query and not import mode - if your datasource supports it. 

[aj1973]

Hi @randika118 

In shared Workspace (Not Premium) a dataset is refreshed up to 8 times a day. Most likely you have benefited from the free trial of Fabric on the workspace where the dataset is. Fabric works only with Premium capacity and for premium capacity you can refresh up to 48 times a day.

[randika118]

Thank you for your response.

It appears that I'll need to acquire a premium capacity, but there seems to be a limitation of 48 refresh occurrences even when using the REST API method.

Could you clarify whether the use of the REST API method for refreshing datasets is restricted, regardless of whether we have PRO or PREMIUM?

Thanks.

[aj1973 · Accepted solution]

Yes up to 8 times for Pro and 48 times using power BI REST API as well