Forum Discussion
Google Analytics Limit Exceeded Error
I'm getting similar issue. Can't even create connection. As error is encountered immediately after I sign in to Google Analytics via the connector and connection isn't created.
It's account that's never been accessed via API. Only through Analytics site.
Still haven't figured out the issue's root cause. But since I needed to wrap up the project, ended up writing python code to fetch data using API and push it to our db. Then have PowerBI quey db through gateway.
I started having this exact problem this week. Up until a few weeks ago it was refreshing and connecting fine. I know that I haven't reached my limit. I can still use other tools to access the GA API (e.g. Sheets plugin). I have the same issue regarding logging in with a different GA account - it just won't connect to GA.
This is a real imediment to completing an important business report this week. If I have to spend time getting my data source from elsewhere then that takes up my analysis time. Microsoft need to fix this. This connector is one of the main reasons I chose to go with Power BI over Excel.
I'm now wondering whether I use Google Sheets to grab the data or a Python script as a few people have mentioned. I'm not familiar with Python - how difficult is it? Are there instructions? Is there a github repository we can download and edit accordingly?
I just noticed this on the Support home page:
Customers who attempt to create a new query or edit their credentials for Google Analytics data sources may get an authentication error when entering their Google account information. In addition, some customers may get authentication errors when refreshing datasets that access Google Analytics data. Engineers are working on the fix to mitigate the issue.Next Update:03/15/2018 2:00 PM PST.
Good to know they're working on it.
