Forum Discussion

richardurrutia's avatar
richardurrutia
New Member
5 years ago
Solved

Google Analytics - data gap

Hello, I'm using the Google Analytics connector on powerbi and I have some issues with the data on powerbi. I always have a gap between the data that I see on Google Analytics and the data imported ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,
I have the same issue. The user number in Google Analytics is around 7K, on the Power BI dashboard is around 19K. 

If I add Google Analytics metrics without adding any GA dimension, the user number matches with the Google Analytics dashboard.

But whenever I add any GA dimension to my report, the user number increases. 

 

Best wishes

Abdullah

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi Anonymous 

     

    Did you try setting a filter on the date column in Power Query Editor? You could provide a start date for it, e.g. the first date of the website when it started to have users. That will filter data to a specific date range.

     

    Jing