Forum Discussion
Google Analytics Limit Exceeded Error
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
https://www.telerik.com/fiddler
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.
