Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
rajulshah
Super User
Super User

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.