Issues with Google Analytics Data

Hi Sbudd ,

There have been similar questions before, and Power BI support gave the following answers.

The TLDR solution is:

• Get your request working in the Google Analytics Query Explorer  with the appropriate date range filters and make sure it says the data is not sampled.
• Apply the same date range filters via a Power Query filter step, and the data should match the query explorer.

For anyone else who runs into this problem, the issue has to do with date range filtering (or lack thereof) with the Google Analytics API.

By default, Power BI doesn't pass any date filtering parameters when it makes the API request, and that's what results in inconsistent data.

For more information, please refer to Solved: Google Analytics goal completions data inconsistency 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.