Google Analytics Dimension Help

[raymond_zedov]

It appears that when I add dimensions to my data cube beyond date, some of my metric totals become incorrect. For example the dashboard on analytics.google.com shows that we had 6,500 users on our site on date X. However when I sum the users for the same data in my PBI dataset at get 7,100 users. Somewhere I have data being duplicated in my PBI cube but not sure where. 

I am using the PBI connector to google analytics to bring in the data for our website. 

[v-zhenbw-msft · Accepted solution]

Hi @raymond_zedov ,

We think this should more relate to google analytic itself, because power bi only pulls data from GA data source without any writeback and customize operations.

I'd like to suggest you take a look at the following documents and resloved post.

Data limits.

Why-google-analytics-connectors-are-useless.

Google-Analytics-users-vs-users-PowerBI.

If you have any question, please kindly ask here and we will try to resolve it?

Best regards,

Community Support Team _ zhenbw

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