Forum Discussion

Tomhayw's avatar
Tomhayw
Icon for Helper I rankHelper I
4 years ago
Solved

Google Analytics data not accurate inside PowerBI

Hi there,

 

I have pulled in website data from Google Analytics but the data does not match up with GA dashboard or even within PowerBI. For example:

This SC shows there were 29 users on 31/10/2019.

 

But when broken down my medium/source, summing those numbers would give you 30 users?!

 

Any help would be greatly appreciated.

 

Thanks,

Tom

 

 

Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Tomhayw ,

     

    For PowerBi, it will first import all the data in the data source and then filter it; however, Google Analytics shows the filtered data (check the filter parameter in the url to see if the filter conditions are added).

    like below:

    https://www.googleapis.com/analytics/v3/data/ga?ids=ga%3A###&start-date=30daysAgo&end-date=yesterday&metrics=ga%3Apageviews&dimensions=ga%3ApagePath&sort=-ga%3Apageviews&filters=ga%3ApagePath%3D%40%2Fprofile%2Faccount

     

    For more details, you can read below similiar solution:

    powerbi - Apply filters to Google Analytics query URI in Power BI - Stack Overflow

     

    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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

2 Replies