Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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? 


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. 



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,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Impactful Individual
Impactful Individual

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?

Impactful Individual
Impactful Individual

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

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!

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors