Forum Discussion

cowork16's avatar
cowork16
Frequent Visitor
9 years ago
Solved

Data from Google Analytics Doesn't Match!

I'm trying to figure out why there are such large discrepancies in data between Google Analytics and Power BI. I know sampling can be an issue but that be the cause of such large differences? Here's ...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    cowork16

     

    I've got response from the product team.

     

    This is expected behavior. The API we're using for Google Analytics is the one available to free users, and that API is known to return less accurate values for high volume sites due to the way it samples data. Unfortunately, the API for Google Analytics Premium customers is significantly different than that for the free users, so we'd need to implement a new connector specifically for Premium in order to get the more accurate values. This is not currently on our roadmap. Customers who would like to see this feature should request it or upvote it (if already there) at ideas.powerbi.com.

     

    Best Regards,

    Herbert

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

cowork16

 

It seems like a data retrieval delay in build-in Google Analytic Connector, you may try some other open-sourced GA connectors, like PQGoogleAnalytics

 

Regards,

cowork16's avatar
cowork16
Frequent Visitor
9 years ago

Thanks for the reply v-sihou-msft :) I set up the connector that you mentioned in your reply and I'm getting the exact same numbers as with the built-in connector. But when I queried directly with PQGoogleAnalytics, the numbers in the Query Editor matched with the GA numbers. So I don't know why, when I put the fields in a report, the numbers are so off.