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.
Got the same issue. Not able to be fixed via that video.
What was interesting was that the 'project' is created for microsoft on behalf of us thus giving the same project ID.
Merx, same issue for me being in Sydney, Australia. bryceicals, interesting observatiob, I wonder if that is affecting it. I put in a support request referencing this thread, so hopefully they look at this feedback. I got a call today in response and they have advised that this is a known issue and the product team are working on this at the moment but that there is no ETA. I'll advise on this forum if I get any further responses.
I'm in Sydney too with a 7pm 'reset'. I haven't been able to test whether I can refresh straight after the reset or not.
Also lodged a ticket and will update anything I hear back.
Edit: Received a phone call with the same details as brndnr.
Im in Victoria, Australia, same issue here to, waited whole weekend and on Tuesday am still getting the same error message, will be following this thread carefully hoping for a quick resolution. Or possibly set me refresh to 7pm est?
