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

Wrong data from Google Analytics

Hey All,

 

I'm currently trying to use Power Bi with Google Analytics. To be clear, I have read the other answers similar to this regarding GA sampling and how that can turn into incorrect results. However our data is nowhere near the capacity limit for GA sampling.

 

The problem I'm having is when I use Sessions, Pageviews, Users and filter the correct dates in Power BI my results are off by a very significant amount (Users will be 222,000 in GA but will say 295,000 in Power BI chart.) Almost every metric is off in Power BI and doesn't reflect what GA has.

 

Has anyone else experienced this? I've been trouble shooting this for a few hours and have found very little information online except for the power bi community.

 

Thanks for any feedback.

3 REPLIES 3
v-sihou-msft
Microsoft
Microsoft

@truemetrics

 

The data trieval from Google Analytics is controlled by GA connector which relies on Google Analytics Reporting API. We cannot guarantee the results of your queries when using this connector.See: Third-party service: Google Analytics connector for Power BI Desktop.

 

Please consult the Google Analytic support: https://developers.google.com/analytics/help/.

 

Also see another similar thread: http://community.powerbi.com/t5/Desktop/Google-Analytics-Pulling-Incorrect-Data-Date-Hierarchy-Not/m...

 

Regards,

ThiBoy
Frequent Visitor

Try to enlarge the period in GA from like the first day of your Website to now. Often it is set to yesterday by default.

 

Hope this solves your problem as well.

ThiBoy
Frequent Visitor

Hey!

 

Got the problems with connecting to GA. E.g. the value of Sessions is higher in Power BI than in GA itself.

 

Hope this problem will be solved soon.

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors