PowerBI show wrong data by connecting with Google Analytics

[Mirev7]

Hello Power BI community,

I would be very grateful if anyone can help me with the following problem.

First of all I get data from Google Analytics for my visuals and the problem now is that when I try to display the E-Commerce Conversion Rate by Week of the Year and Device Category I get totally different percentages/data when compared to Google Analytics (Browser version).

Here, there is a short example:

• at Power Bi Desktop Version I have the numbers 1,73 %,  0,34 % and 0,25 % for desktop, mobile and tablet 
• at Google Analytics there is 1,46, 0,42 % and 0,87 % for desktop, mobile and tablet

2 Pictures of the points mentioned above can be found at my profile.

If anybody of you need further information, I would be glad to give you the input.

Thank you very much for your answers.

[v-yuezhe-msft]

@Mirev7,

This issue could be related to the sample limit in Google Analytics API, you can check  Herbert's reply in this similar thread.

In your scenario, I would recommend you set custom filter as discussed in this thread, then compare the data in Power BI Desktop and Google analytics.

Regards,

Lydia