Forum Discussion
Does the Google Analytics connector bring in full data or sampled data?
We request all of the data. If the underlying data is itself sampled or incomplete, then of course we'd have no control over that -- but we will get everything that the Google API can give us.
"If the number of sessions in the property over the given date range exceeds 500k sessions (25M for Premium)1, Analytics will employ a sampling algorithm which uses a sample set proportional to the distribution of sessions by day for the selected date range."
https://support.google.com/analytics/answer/2637192
I don't know if this means per query in Power BI (my guess would be yes).
This means you need to break down your queries and keep duplicating...not ideal, but it works.
Hello,
I am using the GA connector for power bi.
Then I am exporting the data from powerbi in excel.
Exporting GA side data into excel from GA.
Then mapping both these excel files using VLOOKUP for transaction or order ids.
I see a lot of orders which are there in the GA side are missing in the powerbi side.
So, why don't we get the full transaction ids and the full set of revenues from the GA to the power bi side.
Also, we are using power BI pro account.
So, can someone kindly help? Is the issue due to sampling? Or how to resolve it?
Thanks in advance.
intrasightHelper IV
Because of the way this connector works, if you wish to avoid sampling, you'll have to go elsewhere. See