"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/23/2018 00:00 PDT."
I've been having issues connecting to Google Analytics data sources lately, getting a 403: Daily Limit Exceeded error no matter which account I log in with. This has never been a problem in the past, even when running the same queries. Here's a screenshot of the error:
When I visit that URL "https://console.developers.google.com/apis/api/analytics.googleapis.com/quotas?project=836582736780", I get this error:
Which makes sense, considering I never created any projects using the Google Analytics API dashboard—I've only ever connected to the API via Power BI's Google Analytics connector. When I browse through my projects, nothing shows up.
What's interesting is that I get the same error no matter which account I authenticate with, regardless if I'm using a new .pbix file or an existing one. The project ID in the URL is the same each time, and I'm "over limit" even if I've never used the account with Google's API in the past.
A couple things I noticed is that the project ID, no matter which Google account I authenticate with, is always "836582736780". I was looking for a solution and stumbled onto this thread, which has an identical URL, down to the project ID, which suggests that this may be an issue with Power BI, not necessarily Google Analytics (the accepted response in the other thread is to read Google's documentation since it's a Google error).
Hoping someone can shed some light on what may be causing this issue, and how it can be fixed or worked around.
I had the same problem, found the answer in this video: https://www.youtube.com/watch?v=CN5ch2hUS7s
The video describes the problem (and why it happens) between the 1:30 and 6:40 time points. It helped me to watch the whole thing, but if you're impatient the actual solution starts at the 8:45 time point.
Here's a summary:
CAUSE: By default, Power BI attempts to pull ALL data from GA...that could mean thousands or millions of records that you don't actually need, but they count against your daily quota.
SOLUTION: Use filter(s) to reduce the amount of data you’re pulling from Google Analytics to Power BI. Filter the query to only pull the date range you need.
IMPORTANT BEST PRACTICE: Use specific dates to define your desired date range in the query filter. Don't use presets like "This Month" or "Last Month" This ensures you're filtering on the datastream from the GA datacube instead of a locally cached subsample. The video explains this between 9:45 and 12:30.
Thanks for the insight! The video is definitely helpful, and it explains why I can't access the project in the dev console, and could explain why I have the same project ID as another user.
However, I'm not sure the solution solves the problem I have. Even as recent as last week, my auto-refreshes have been working just fine, and I haven't hit the limits before—unless the limits have been changed recently, I don't think I should be hitting them with my queries. Right now, I can't even update my queries to do any tests because they're not loading thanks to this limit.
Also, even when I try authenticating with a Google Analytics account that I've never used in Power BI, regardless which Power BI account I'm logged in to, I'm getting that 403 error before I can even select an account, property or view, much less call a single row of data. I just don't understand how, with a brand new account, I'm already hitting a quota when I've never pinged the API.
We are currently getting this same error when just attempting a connect to GA. Is there any resolution on this? Is it possible the PowerBI has exceeded their daily limit for their project at this point?
I've not got experience with google analytics but I had limit problems with the musicbrainz api. I was getting errors on some calls due to the speed I was asking for data.
I used fiddler to help
It showed me the api calls, data and responses.
Oddly some of my queries seemd to make multple calls for the same data.
I didn't have to much data so I just put in a pause to stop it reqesting too many times a minute.
I also was able to send my users details to help the api.
I am having the exact same issue. The amount of data I'm pulling back is very small, so I don't believe its a data volume issue.
I try to view the API usage statistics from the API Dashboard, but nothing is showing.
Is it possible that the quota is being shared across multiple independent users of the Power BI API Connector?
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.