Forum Discussion
Wrong data from Google Analytics Custom Dimensions
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!
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
2 Replies
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
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