Google Analytics Session Duration 101

[SuperKhazd0rf]

Dear community, 

I'm using the official Google Analytics connector, but a few question are raising. 

I created a simple query including the following dimensions : Country, Session Duration, Sessions. 

I need the session duration to recreate my GA Segment (sessions > 30seconds).

I'm surprised to see many 101 values showing up, aswell as 202, 302, 403... 

Another thing worrying me, is the total session is very different from the data I have in both Google analytics & Tableau. 

Do you have any idea on how to solve this?

Thanks a lot,

[v-juanli-msft · Accepted solution]

Hi @SuperKhazd0rf 

It seems your happen to the problem: data from Google Analytics doesn't match with data imported into Power BI.

If so, please refer to similar threads:

https://community.powerbi.com/t5/Desktop/Data-from-GA-is-incorrect/td-p/563629

https://community.powerbi.com/t5/Power-Query/GA-Data-does-not-match-in-Desktop-Web-Original/m-p/1326...

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.