Reply
Echoy51
Frequent Visitor
Partially syndicated - Outbound

Refreshing Issue

I have set 6 times daily refresh for my report, but I kept getting email like this:

Echoy51_0-1734308867075.png

Echoy51_1-1734308883719.png

This error frequency occurred 1-4 times a day...How to avoid this situation happening?

 

Many thanks,

 

Echo

 

1 ACCEPTED SOLUTION
v-hashadapu
Community Support
Community Support

Syndicated - Outbound

Hi @Echoy51 ,Thank you for reaching out to Microsoft Fabric Community Forum.

Please consider reducing the refresh frequency. As:

1. Power BI has limits on how frequently data can be refreshed, especially if you're using an external data source (e.g., a web service) with Web.Contents calls. If you're hitting the data source too frequently (e.g., 6 refreshes daily), you might be triggering rate limits on the source's API, leading to a 429 status code.

2. Power BI itself has limits on the number of refresh operations that can be performed on a dataset within a given time period, especially for free and Pro licenses. If you refresh too often within a short span, this can lead to throttling.

3. If you're pulling data from an external API (via Web.Contents), the external service may have its own rate limits (e.g., only allowing a certain number of requests per minute or hour).

If this post helps, please mark it ‘Accept as Solution’, so others with similar queries may find it more easily.

View solution in original post

2 REPLIES 2
v-hashadapu
Community Support
Community Support

Syndicated - Outbound

Hi @Echoy51 ,Thank you for reaching out to Microsoft Fabric Community Forum.

Please consider reducing the refresh frequency. As:

1. Power BI has limits on how frequently data can be refreshed, especially if you're using an external data source (e.g., a web service) with Web.Contents calls. If you're hitting the data source too frequently (e.g., 6 refreshes daily), you might be triggering rate limits on the source's API, leading to a 429 status code.

2. Power BI itself has limits on the number of refresh operations that can be performed on a dataset within a given time period, especially for free and Pro licenses. If you refresh too often within a short span, this can lead to throttling.

3. If you're pulling data from an external API (via Web.Contents), the external service may have its own rate limits (e.g., only allowing a certain number of requests per minute or hour).

If this post helps, please mark it ‘Accept as Solution’, so others with similar queries may find it more easily.

lbendlin
Super User
Super User

Syndicated - Outbound

Run fewer requests if you want to avoid the 429.  group them better.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)