Diff in google analytics data

[fredrikahnell]

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?

[Anonymous · Accepted solution]

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