Manual Refresh Time Outs

[JustSayJoe]

I have a few data connections to Google Sheets for some really small tables (less than a 1,000 rows).

I'm not scheduling my refresh through the Service. I'm simply doing a manual refresh on these data sources by right-clicking on them in Power BI Desktop, and selecting the Refresh data option. I am the only person with access to these Google Sheets. There is no automated refresh occurring on them when I manually refresh source in Desktop. However, they CONSISTENTLY time out with the "too many requests" error message in Desktop. They're being refresh one at a time. No other requests are running at the time, but Google Sheets ALWAYS has this issue when performing a manual refresh.

Does anybody know why this is or how to prevent it? It is really annoying. Thanks in advance.

[rajendraongole1]

Hi @JustSayJoe -The "Too many requests" error you're seeing when refreshing Google Sheets in Power BI Desktop is likely due to API limitations imposed by Google Sheets. Even with a small number of rows, Google Sheets imposes rate limits on API requests, which Power BI may exceed during refreshes, particularly if there are multiple queries or connections happening in a short time frame.

If you're using your personal Google credentials, switching to a service account (or OAuth 2.0 credentials) with access to the Google Sheets could help. Service accounts often have higher API quotas compared to standard user accounts.

If the refresh continues to be an issue, you might consider enabling incremental refresh in Power BI for Google Sheets, which would refresh only new or changed data. Although this does not completely remove the risk of hitting Google API limits, it could reduce the number of rows and queries that need to be refreshed.

If none of these strategies work, it might be worth reaching out to Google Cloud support to check if there are specific API limits tied to your account that could be adjusted.

reference links:

Solved: Refresh Google Sheets in Power BI - Microsoft Fabric Community

Hope this information helps.