Data from Google Analytics into Power bi and in Google DataStudio is not matched .. big difference

[Anonymous]

Hi All,
In my organization there some Data Studio charts created from Google Analytics data. Now I am creating the same in Power-bi from the same source i.e Google Analytics. There is huge difference between those two reports. I found one blog that there is sampling power-bi does if there is too many data loaded from Google analytics. But at least count matches nearby but it is showing huge difference.
Can someone please help me here if any workaround/way/solution to reconcile those two reports.

Thanks,

Ganesh

[ReportBuilder07]

Hi, I had some sampling issues more than once when exporting GA data to PBI. As a workaround, maybe you can connect your data using a 3rd party connector. I currently use Windsor.ai's GA connector and I haven't had any other sampling issue. In case you wonder, to make the connection first search for the GA4 connector in the data sources list:

After that, just grant access to your GA account using your credentials, then on preview and destination page you will see a preview of your GA fields:

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url.

[jagdalegmail]

Hi 

As you have mention, I have tried to set SamplingLevel but it gives the below errror. Please let me know if I am missing something here. 

Error: Expression Error : The name "SamplingLevel" wasn't recognized

[v-xulin-mstf]

Hi @jagdalegmail,

You need add this code in the advanced editor.

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[jagdalegmail]

Hi v-sulin-mstf,

Thanks for the reply.

Looks like you forgot to add code snippet. 

I have already try to add that SampleLevel code in advanded editor.

Thanks,

Ganesh

[v-xulin-mstf]

Hi @Anonymous

Please try this:

Query editor>>add this code: #"samplingLevel" = HIGHER_PRECISION in each GA table.

For more information, please refer:

https://community.powerbi.com/t5/Desktop/Problem-with-Google-Analytics-data/td-p/965367

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[jagdalegmail]

Thanks for reply. 

As you have mention, I have tried to set SamplingLevel but it gives the below errror. Please let me know if I am missing something here. 

Error: Expression Error : The name "SamplingLevel" wasn't recognized

Thanks,

ganesh