Forum Discussion

cristianj's avatar
cristianj
Helper IV
2 years ago

Errors refreshing data from google sheets

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.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.