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.
Power BI TeamWe 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.
Is there any indicator within Power BI Desktop that denotes that the data is sampled? The API would at least tell you it's not bringing in the full dataset, I believe.
No indicator. Interestingly enough this thread has an admin answer of the connection (content pack) only pulling the last 6 months. Here
Thanks for the reply and related link - it's great to know the Desktop connection is the same as the one used in the content pack. The content pack doesn't fit our needs because of the year-over-year analysis needed, but I still find it strange that no indicator is provided for sampled data in the Desktop app. Hoping to see this connection improved in a future release.
I would suggest to use https://scitylana.com instead. This will pull all raw data unsampled from GA (free edition) into Power BI.
