Google Analytics and Power BI

[SKamp]

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!

[v-kkf-msft]

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]

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.

[kymramosrpo]

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

[cassidy]

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

[kymramosrpo]

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:

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!