Refreshing Issue

[Echoy51]

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

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

Many thanks,

Echo

[v-hashadapu · Accepted solution]

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]

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