Forum Discussion
andrescaso
6 years agoResolver I
Problem with Google Analytics data
Hi all, I connected GA to the desktop version of Power BI, but the data (in days, users, and channel) in BI doesn't match with GA reports. After reading a lot of post, I was filter between dates in P...
- 6 years agoThanks @v-eachen-msft , By the way, I find a brief job to fix this problem, in the advanced editor you must add this code: #"samplingLevel" = HIGHER_PRECISION in each GA table,meanwhile vote in this post https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39361177-data-credential-issues-i... with the same problem
andrescaso
5 years agoResolver I
Try to filter your table in power query by dates, at some point your data in power bi is the same than google analytics
Regards
CmdrKeene
5 years agoHelper IV
You'd think so, but it's not. I think the blame rests with Google, but I don't know what to do about it.
In the very first step the data is already wrong because Google tries to send all data without filters, and if there are more rows than the return limit it just truncates the rest, and the data is never correct in PowerBI.