Forum Discussion
Google Analytics Request failed (403) Error
The video describes a similar 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.
Hi rwurgler,
Thanks for your reply. I can see how that would help, but I'm trying to bring in a completely new data set from Google Analytics, from a login of someone who has never used Power BI or the Google Analytics API.... and it won't even let us get past the login section of 'Get Data'. Therefore there is no way to get to the filtering stage. Aside from this, surely Power BI isn't going to make us filter every single data set as this is very inefficient.
For us it is really an issue as we are located in Singapore and can't use Power BI until 4 pm and the quota gets reset.
So it is actively blocking our business.
Adding a custom API key would be a solution or simply increase quota limit for this project (which seems to be a shared project of Microsoft for all Power BI users as we get the exact same error with the same url)
