Errors refreshing data from google sheets

[cristianj]

Hello
Lately the majority of refresh errors where due to google sheets,
First of them is "Too many requests " error which i was reading on the net but i did not find a suitable solution

Second one is due to error at google credentials, so i have to reenter the password, which is not changed. 

Do you have this kind of problems, and maybe you find a working solution.

Thank you.

[Anonymous]

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.