Forum Discussion

Regular Visitor

8 years ago

Wrong data from Google Analytics

Hi All, This is my first time to contect to Google Analytics using Power BI Desktop. I started with something simple by getting only "Users" by date. However the result I've got loaded to Power...

Need Help

fmatioli06

Frequent Visitor

8 years ago

Hi MF_Wong,

I just figured this out today.

The reason the numbers do not match is due to the sampling limit from google.

Here is what I did and worked:

1- Go to your Query Editor and filter your report using your date field.

2- Add a custom filter (do not use "Equals..., Before..., After... so on, custome is the only way to prevent sampling).

3- Within the custom filter then you can set your filter. I did a range: "is after and equal and is before and equal". I then compared to the same time period on Google Analytics and my data matched!

With the custom filter you are filtering within the cube and not locally on your powerbi desktop so you are able to work around sampling.

Hope this helps,