Forum Discussion

rajulshah's avatar
rajulshah
Resident Rockstar
3 years ago
Solved

Retry attempts for failures while executing the refresh exceeded the retry limit set on the request

Hello everyone,   I am refreshing the Power BI Dataset using XMLA Endpoints, i.e., refreshing only specific partitions. I am using Power Automate to do this. The flow executed for almost 3/4th of t...
  • lbendlin's avatar
    3 years ago

    If the dataset resides on a Premium capacity, you can schedule up to 48 refreshes per day in the dataset settings. For more information, see Configure scheduled refresh later in this article. Datasets on a Premium capacity with the XMLA endpoint enabled for read-write support unlimited refresh operations when configured programmatically with TMSL or PowerShell.

    It's also important to call out that the shared-capacity limitation for daily refreshes applies to both scheduled refreshes and API refreshes combined. You can also trigger an on-demand refresh by selecting Refresh now in the dataset menu, as the following screenshot depicts. On-demand refreshes aren't included in the refresh limitation. Also note that datasets on a Premium capacity don't impose limitations for API refreshes.

     

    Data refresh in Power BI - Power BI | Microsoft Learn

     

    What capacity are you on? Note that your limit may also come from using Power Automate.  Try switching to Powershell.