Forum Discussion

jcabeza's avatar
jcabeza
Frequent Visitor
9 years ago

user measure google analytics

I have wrong data from Google Analytics to PowerBI, they are different than data in Google Analytics in "user" measure.          
Need Help
Ram_DCT's avatar
Ram_DCT
Helper II
8 years ago

Hi Team,

 

Please help me out here, even I am facing the same issue with count of users not matching with actual GA users. 

 

Thanks,

Ram

  • RolandKramer's avatar
    RolandKramer
    Frequent Visitor
    8 years ago

    Hi there,

     

    Same issue for me. This is what happens:

    When I load 'Pageviews', 'Session', 'Bounce rate', etc. it looks all good. The values are identical to what is measured in Google Analytics.

    But when I combine these data with the metric 'Users' or 'Number of sessions per user' all data is wrong. 

     

    This tells me that all data is up-to-date, except the 'Users' metrics, which affects other metrics when loaded in the same sheet. 

     

    Hope this extra info helps. 

    • Ram_DCT's avatar
      Ram_DCT
      Helper II
      8 years ago

      Thank you Roland! Let's see if we get any attention from BI Dev team.

       

      -Ram

      • GilbertQ's avatar
        GilbertQ
        Super User
        8 years ago
        You have to remember that the Google Analytics is a cube. So when you are using measures across different dimensions this will appear to make the numbers incorrect.

        But if you get them individually they will be correct. So one way around this is to bring in the common ones together. And then merge them in Power BI Desktop in the Query editor.