Forum Discussion

mmanwaring's avatar
mmanwaring
Resolver I
8 years ago
Solved

Google Analytics - Limit exceeded

Hello All, I have without issues been using a daily refresh using the built in api for google analytics. Recently however i get this error.     When i go to the URL is says "Fail to load" ...
Need Help
  • rwurgler's avatar
    rwurgler
    8 years ago

    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.