Forum Discussion
Wrong data from Google Analytics
Hi All, This is my first time to contect to Google Analytics using Power BI Desktop. I started with something simple by getting only "Users" by date. However the result I've got loaded to Power...
Hi Xiaoxin,
Thank you for your feedback.
However i think it may not be related to api delay. If that's a delay issue, only data of past (few) days will have impact, right? When I compare the data downloaded from the G.A Web to the data generated via Power BI Desktop for a long period of time (more than one year), none of the data matches.
| = Cube.Transform(#"xxxxxxxx", |
| { |
| {Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}}, |
| {Cube.AddMeasureColumn, "New Users", "ga:newUsers"}, |
| {Cube.AddMeasureColumn, "Users", "ga:users"} |
| }) |
The above is the code generated from "Add item" step in Power BI Desektop.
Any idea?
Appreciate feedback.
Regards,
HI MF_Wong,
I also not so sure for internal modification in google analytics connector, maybe you can try to use odata with google api and compare with google analysis web data.
In addition, you can also contact to google analytics support to known more about this.
Regards,
Xiaoxin Sheng