Errors refreshing data from google sheets

Hi cristianj ,

Too Many Requests Error typically occurs when you exceed the rate limit imposed by the API or service you're querying. In the context of Power BI and Google Sheets, this can happen if you're making too many requests within a short period.
Distribute your data refreshes: Instead of refreshing all your data sources at once, try to spread them out over time. This can help avoid hitting the rate limit. And if you're using Power BI Pro or Premium, consider adjusting the frequency of your refreshes.

Google Credentials Error might be due to expired cached credentials. Sometimes, clearing your internet browser cache can resolve credential issues. After clearing the cache, sign in to Power BI and navigate to

https://app.powerbi.com?alwaysPromptForContentProviderCreds=true

This URL forces an update of your credentials, potentially resolving the issue.

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.