Still got wrong data from Google Analytics

[TD]

Hi,

i imported a lot of data from GA to Power BI Desktop, and some outcomes are not the same like Entrance or Pageviews. In some results there is a small difference but in other there are really big differences. Is the Problem with the limitation from Google still current? 

I did the Workaround from @fso:
- Check your GA data you have imported in PBI and note down the date range you have imported (earliest and latest date)
- Go to https://ga-dev-tools.appspot.com/query-explorer/

- Set up exactly the same query and use the same dates that you have in PBI

- Hit "Run Query" and have a look at the header section of the result

If it says "Contains sampled data:Yes", then you know, that sampling is the root of the issue.
The only way around it is to request smaller date ranges of data, which you cannot do in PBI itself. So you will have to programmaticly do that elsewhere and use the result as a source for PBI.

But the header shows me: 

• Contains sampled data:No

But still i don't get the right values on PBI!

This is a main reason for our company to select Power BI or an other BI Tool. Is there an easy workaround or something else? 

Thank You!

[v-ljerr-msft]

Hi @TD,

An alternative way to verify if it is an sampling issue is using Fiddler, capture the outgoing request when you refresh the Query. Analyze the URL and parameters, see if there is anything odd.

Another possibility is that the Google Analytics API may change in a way that affects the results of the queries generated by PBI, as the Google Analytics connector relies on Google Analytics API(Third-Party Service). More details on changes to the Google Analytics API can be found in their changelog.

In addition, I would suggest that you also create a support ticket on Power BI Support page for better assistance on this issue. 

Regards