Wrong data from Google Analytics

Hi kendash,
if there are several blocks of rows that have the same value as you describe, this is a strong indication that your data is sampled.
(https://support.google.com/analytics/answer/2637192?hl=en)
"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"

Here's how you can verify if that's the case:
- 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.