cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rajulshah
Memorable Member
Memorable Member

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 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.

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.