Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SKamp
Regular Visitor

Google Analytics and Power BI

When trying to connect Power BI Desktop to our Google Analytics, we are finding that we can't change the selected date ranges of data being pulled in.  I believe that this is causing the data to be sampled and we are not seeing all of our campaigns. 

Any thoughts on how to bypass the thrid party connector or how to change the date selection so that we can see all of our campaigns? Or any other ideas on why we would only see ~20 campaigns in Power BI but ~ 1,000 in GA? 

Thanks!

5 REPLIES 5
v-kkf-msft
Community Support
Community Support

Hi @SKamp ,

 

When date ranges are very large, Google Analytics will return only a subset of values. To make sure that the data you're seeing is the same as you would get from Google Analytics, you can execute the query yourself in Google's interactive tool. To understand what data Power Query is retrieving, you can use Query Diagnostics to understand what query parameters are being sent to Google Analytics.

 

You can use the process described in this document to understand what dates are being retrieved.

https://docs.microsoft.com/power-query/connectors/googleanalytics#validating-unexpected-data 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

cassidy
Power Participant
Power Participant

This may or may not be helpful, but I gave up my fight with Google Analytics and BI and started converting everything to pulling from Google BigQuery instead.  With BigQuery, you can use normal SQL statements for the most part and the data won't be sampled.  This assumes you have GA feeding BigQuery.

 

The drawback is that the prior day's data is often not ready until late morning and at random times.

Hi! Thank you for the suggestion. Can you share with us how to connect to Google BigQuery?

BigQuery is a built in Power BI connector.  Once connected, it acts similar to a SQL database

https://learn.microsoft.com/en-us/power-query/connectors/google-bigquery

Thank you for the reply. Reading my question again I've realized that it's too vague/general.
I was able to connect to Google BigQuery but I could only access publicly available data:

kymramosrpo_0-1695807596520.png

I would like to know how can I connect to our data? Is there a similar community for Google Analytics where I can ask raise questions? Thank you!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.