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

[rajulshah]

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 the day and then it threw the below error:
"Retry attempts for failures while executing the refresh exceeded the retry limit set on the request"

I also calculated the total number of refreshes and roughly it threw the error after 60 refreshes.
Can anyone guide me as to what the error is and how can we resolve this issue?
Thanks in advance.

[lbendlin · Accepted solution]

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.