cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mmanwaring Regular Visitor
Regular Visitor

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.

 

 

Screenshot_1.png

When i go to the URL is says "Fail to load" as i am guessing this project is not attached to an account of sorts?

So i went ahead and created an account for using the google apis and can create a project etc. (not sure how to link it to the above project id)

 

My problem is that i have no information on how to connect to google analytics outside of the provided connectors.

 

Please, if anyone has had experience with this issue and can point me in the right direction or provide a solution that would be awesome.

Thanks

Mike

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Microsoft v-huizhn-msft
Microsoft

Re: Google Analytics - Limit exceeded

Hi @mmanwaring,

It seems to be an error from google analytics API but not from Power BI side. Please refer to this document. You can consult more problem about API in Power BI developer community.

1.PNG

Best Regards,
Angelia

View solution in original post

rwurgler Frequent Visitor
Frequent Visitor

Re: Google Analytics - Limit exceeded

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.

View solution in original post

4 REPLIES 4
Microsoft v-huizhn-msft
Microsoft

Re: Google Analytics - Limit exceeded

Hi @mmanwaring,

It seems to be an error from google analytics API but not from Power BI side. Please refer to this document. You can consult more problem about API in Power BI developer community.

1.PNG

Best Regards,
Angelia

View solution in original post

rwurgler Frequent Visitor
Frequent Visitor

Re: Google Analytics - Limit exceeded

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.

View solution in original post

mmanwaring Regular Visitor
Regular Visitor

Re: Google Analytics - Limit exceeded

Hi rwurgler

Thank you for posting this.

I must have skipped over this video as i follow Ruths channel 🙂

 

i will look closer at my solution and clean up the data requests.

 

regards

Mike

Anonymous
Not applicable

Re: Google Analytics - Limit exceeded

Hi @mmanwaring, @v-huizhn-msft!

I´m having problems with GA Api. I found this post and I applied the solution of the video but didn't work for me.
Now I have a different error but continues without refresh....

 

Captura.PNG

 

Any Idea?

Thanks

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors