Wrong data from Google Analytics Custom Dimensions

[Anonymous]

Hello,

I am pulling in data from Google Analytics into PowerBI. If I just pull in the event data (category/action/label) from Google Analytics - all of my numbers are correct and match the GA web report. However, every time I add a custom dimension to my data - my numbers become maybe 15-20% off the GA web numbers. I can't find a consistent trend because sometimes the PowerBI data is greater or less than my GA data.

Also, all of these events have a custom dimension specified for them, so I don't think it has anything to do with null values. Any ideas on why my custom dimensions skew my numbers?

Thank you for the help!

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

In Power BI desktop, the connector connect to Google Analytics rely on the Google Analytics Core Reporting API. The API may change in a way that affects the results of the queries we generate. Please refer to this article: Google Analytics connector for Power BI Desktop.

Regards,

Daniel He