Forum Discussion
Helper ITransaction id from Google Analytics connector
I am using the Google analytics connector to get the transaction ids with channel grouping within certain dates.
When I export directly from google analytics (actual) and compare with what I get from the google analytics connector, the connector in power BI gives me way way less transaction ids.
How do I fix this?
cube transform:
= Cube.Transform(#"XXXXXXXXXX",
{{Cube.AddAndExpandDimensionColumn, "ga:channelGrouping", {"ga:channelGrouping"}, {"Default Channel Grouping"}}, {Cube.AddAndExpandDimensionColumn, "ga:transactionId", {"ga:transactionId"}, {"Transaction ID"}}, {Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}}, {Cube.AddMeasureColumn, "Revenue", "ga:transactionRevenue"}})"ga:date"}, {"Date"}}, {Cube.AddMeasureColumn, "Revenue", "ga:transactionRevenue"}})
Thank you :)
I got the right data by linking google analytics to a google doc with a scheduled refresh instead of directly into BI.And I connected BI to this google doc.
2 Replies
v-yulgu-msftMicrosoft Employee
Hi purnima13,
The Google Analytics connector in Power BI Desktop rely on the Google Analytics Core Reporting API. Although Power BI attempt to release updates in accordance with API changes. It cannot guarantee the results of your queries when using this connector. I would suggest you contact with Google Analytics support for further analysis.
Besides, here are two similar thread about Google Analytics connector issues:
Data from Google Analytics Doesn't Match!
GA API issues for transactions
Best regards,
Yuliana Gu
purnima13Thank you :)
I got the right data by linking google analytics to a google doc with a scheduled refresh instead of directly into BI.And I connected BI to this google doc.