Forum Discussion

Japanisu's avatar
Japanisu
Frequent Visitor
7 years ago

Trying to refresh Power BI dataset via API using Flow

Hi,   I have created a custom connector in Flow following this tutorial  https://medium.com/@Konstantinos_Ioannou/refresh-powerbi-dataset-with-microsoft-flow-73836c727c33.   It is working fine b...
Need Help
jesus21282's avatar
jesus21282
Frequent Visitor
7 years ago

I received the same error calling the API using Flow.

 

I found a news article from Power BI on 2017 https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/ where they state:

 

"Note: if the dataset is not in a workspace assigned to Premium capacity, then you will be limited to eight refreshes per day. Datasets in workspaces assigned to Premium will support up to 48 refreshes a day."

 

but I still do not know if this limit is for the API only PLUS the 8 Scheduled refreshes we got from the service in non-premium-capacity, OR the sum of both API calls and sched-refreshes must not go above 8 altogether.

 

Hopefully the will lift the limitation or increase the refresh limits soon.

  • Japanisu's avatar
    Japanisu
    Frequent Visitor
    7 years ago

    Thanks for your reply jesus21282.

     

    I just find it weird I'm getting the error even when only doing the refresh (8x) by calling API via Flow, no refresh via the service or manual refresh done.

     

    I logged a ticket with Power BI but haven't gotten any explanation for the error yet.  

    • jesus21282's avatar
      jesus21282
      Frequent Visitor
      7 years ago
      Japanisu

      Hi, yes, it turns that right now I am getting the same exact issue.

      I decided to turn the Flow off this morning, and tomorrow afternoon I will turn it back on to see if it succeeds again because right now it's failing every single time due to the refresh limit.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    Any solution? I am facing the same issue!! Even after 48 hours, when I try to refresh the API, i am getting error as,"Invalid dataset refresh request. Number of refresh requests in last 24 hours exceeded limit".

     

    Any help, much appreciated!! Please let me know.