Anonymous
2 years agoNot applicable
Status:
Investigating
Too many requests when using Google Sheets connector
I use the Google sheets connector in Power Query to get information from several Google Sheets into several datasets. It worked great but somehow since a couple of months I am reaching the limit for...
ryan0585
Advocate II
2 years agoSounds like Microsoft needs to limit how many calls they're sending to the Google API via Power BI. First the query evaluates, then it runs, yada yada yada.
I'd love an option to skip the evaluation step for things like this... too many queries for a simple refresh, and I feel like that's what's happening here.
I don't want to get on the phone with a Microsoft rep just to have someone tell me what I already know. I just want better Google Sheets integration.