Forum Discussion

randika118's avatar
randika118
Helper I
2 years ago
Solved

Power Automation flow error to Refresh the Power BI dataset

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

 

  • aj1973's avatar
    aj1973
    2 years ago

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

4 Replies

  • aj1973's avatar
    aj1973
    Community Champion

    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's avatar
      randika118
      Helper I

      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's avatar
        aj1973
        Community Champion

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

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional

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