Google Analytics wrong data

[WBackOffice]

Hi community

I´m having problems with getting the right data from Google Analytics. It´s seems that GA samples my data, even if it´s much, and returns very odd numbers.

I have been seeing this problem often in this forum, and the only "solution" I read is to work with short periods of time (or low amount data). But even with the report I´m working on, with few data, the problems still persist.

I tried with https://ga-dev-tools.web.app/query-explorer/ but didn´t help.

Is there a way work with GA without this issues?

[Adel]

hello, yeah it's a known issue, the only solution that worked for many people is to use a data warehouse.
https://windsor.ai/sampling-in-google-analytics-how-to-avoid-it/

[v-chenwuz-msft]

Hi @WBackOffice ,

The Google Analytics connector in Power BI Desktop relies on the Google Analytics Core Reporting API. As such, features and availability may vary over time. Due to this dependency, Power BI cannot guarantee the results of your queries when using this connector.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-google-analytics-connector 

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.