Forum Discussion

jimmymitra's avatar
jimmymitra
Advocate I
8 years ago

Google Analytics Request failed (403) Error

I am getting below error while trying to connect google analytics from Power BI , I could able to connect it before and did not have any problem , but now starting to get the below error    GoogleA...
Need Help
rwurgler's avatar
rwurgler
New Member
8 years ago
This video may help: https://www.youtube.com/watch?v=CN5ch2hUS7s
 
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.
  • brndnr's avatar
    brndnr
    Regular Visitor
    8 years ago

    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.

    • merx's avatar
      merx
      Regular Visitor
      8 years ago

      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)

  • bryceicals's avatar
    bryceicals
    Frequent Visitor
    8 years ago

    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.

    • brndnr's avatar
      brndnr
      Regular Visitor
      8 years ago

      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.

      • bryceicals's avatar
        bryceicals
        Frequent Visitor
        8 years ago

        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.