Diff in google analytics data

fredrikahnell — Tue, 14 Apr 2020 13:53:45 GMT

Just started to try out to get data from google analytics but can't get my head around it.

I started simple but still get a big difference between analytics page and in power bi depend on what dimensions I select, and non of them match what shows in Analytics.

Diff between two table setups. I created two loads, Data 1 and Data 2, the only difference is that Data 2 has the dimension Source included.

When I aggregate the data, I get different in the metrics I have.

When looking in Google Analytics web, it shows in March I have 125,486 users, that is completely off from the two tables I have loaded in power bi. I am using the same property and view.

Anyone else that has stumble upon this and can guide me in what I am doing wrong?

Re: Diff in google analytics data

Anonymous — Tue, 21 Apr 2020 01:21:40 GMT

HI @fredrikahnell,

I think this should more relate to google analytic itself, power bi only pulls data from GA data source without any writeback and customize operations.
I'd like to suggest you take a look at the following document about data limitation about google analytic:

GA Data limits

Regards,

Xiaoxin Sheng

topic Diff in google analytics data in Developer

Diff in google analytics data

Re: Diff in google analytics data