Forum Discussion
Error (429) Too Many Requests - Google Sheets connection
Hi everyone, I tried to get my answer from other questions about the same problem but I couldn't find anything useful to me. Basically I have a Dashboard with a Google Sheet connection and, f...
Hi maybe my suggestion could help you.
The issue there is that power query send GET request for all sources at the same time and google basicaly can't handle big amout of request in one moment.
I have figureit out by create separate appended google sheet trough google sheets functions QEUERY and IMPORTRANGE which allows you to basicaly merge tables into one inside google infrastructure and use resulted table within powerbi