Forum Discussion
Google Analytics issue: Request failed (403): Quota exceeded
Hi Paulien1989 ,
This is a known issue which was published in Power BI Support , see more:
Power BI users connecting to a Google Analytics data source may experience issues while authenticating. As a workaround, customers can republish the dataset from the Power BI Desktop app. Engineers are working with Google to mitigate the issue and a fix will be provided by end of week 12/20/2019.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The authentication issue appears to be seperate from this issue that I posted (and others confirmed). The authentication issue is solved and I can now login again without problems.
But the "quota exceeded" issue still persists and it occurs with all my clients that run Power BI reports with the Google Analytics connector. I, too, found a possible method online about increasing the limit in the Google Developer Console. But for me, too, the project ID mentioned in my refresh error does not match any project I have running under my credentials (specifically, I don't seem to have any projects running under my credentials....). So I cannot increase the limit.
Since I am not the only one experiencing this issue, it's a general one and not for me specific. I can imagine this might be a thing for Google, because the connector is a third-party. But I'm sure Power BI as a relation with Google on this matter. Are you talking with Google about this issue? What is the status, is it going to be solved soon?
A work around is to refresh the report in Desktop and publish it again to Service, then it does work. But then scheduled refresh fails 9/10 times, which of course is not acceptable. So please let me know what the status is concerning this unrecorded but apparantly 'known' issue.
Same problem here.
Same problem here.
Rasing the query limit in Google developers console for my own projects has no effect. Projectnumber in the error does not match any of my own, and I'm no where near the limit for my own projects.
Hi all,
I just wanted to follow up on this issue. I raised a support ticked with Microsoft, and after a thorough search of posible errors, the conclusion was as follows:
All API calls form Power BI Service to Google Analytics are processed under a shared project id handled by Microsoft. The product team is aware of the limitations this is causing to the clients, but they currently can't provide a garantied work around. Their current recommendation is: "try rescheduling the refresh to another time of day if possible".
I hope Microsoft will be able to sort it out with Google soon. I'm still hitting this error frequently each week. For now I'll will go with some extra backup refreshes on differnt times during the day, and hope at least one of them succeds.
Please find the repsonse from the Power BI Product Group Team below:
I have discussed with our PG Team regarding error that you have received " GoogleAnalytics: Request failed (403): Quota exceeded for quota group 'default' and limit 'Queries per 100 seconds' of service 'analytics.googleapis.com' for consumer 'project_number:664933364861' and below are the comments sent on that error by our PG Team.
"Microsoft use two different client ids, one for PowerBI.com (664933364861) and one for PBI Desktop. All customers under PowerBI.com run under the same id. The client Id in the error mentioned is for PowerBI.com, and as you can see the quotas are already set quite high. In fact there's no way for us to increase them further. We've been in contact with Google in the past about getting a special exemption to the quotas, but there was some blocker, I believe it was due to technical issues. As of right now we can provide no guaranteed work around. I'd recommend try rescheduling the refresh to another time of day if possible".Best,
Torben
