GA Data does not Match, Power Bi loads interesting Data

[Keha]

Hey there,

i noticed that in PB Desktop the count of "User (Besucher)" is a bit higher for the Month March (01.03.2017 - 06.03.2017) is a bit different then the count in GA original. Power Bi is giving me 7 Users, GA is giving me 5. 

I have dug through the Data a little bit and I noticed that Power Bi is counting two more Users in that are not being considered in GA. Probably because they are not showing any data (no session, no pageview, etc.). (Picture Row 6&7)

For the same time period in GA i get the results below with account for the 5 without the two "phantom" ones. 

Do you guys have any suggestions for where this decrapancy is coming from? As you can see I have already tried applying User Id to make the analytics more precise but this is stiring up my reporting big time. 

Thank you in advance! If there is anything else of interesst I can provide please ask at anytime. Any help is deeply appreciated. 

Cheers 🙂

[v-qiuyu-msft]

Hi @Keha,

Google Analytics connector in Power BI Desktop rely on the Google Analytics Core Reporting API. Due to this dependency we cannot guarantee the results of your queries when using this connector. See: Google Analytics connector for Power BI Desktop.

In your scenario, please try to update the desktop to latest version 2.44.4675.422. Also please verify Google Analytics Reporting API results during Month March (01.03.2017 - 06.03.2017). For more information about using this API, you can post a thread here as suggested from this article.

Best Regards,
Qiuyun Yu