Issue with loading Google Analytics data into PowerBi

[Syndicate_Admin]

Hello

I'm creating a report with Google Analytics metrics, but two tabs of the report don't load all the data that does load the rest. For example, they only charge 2017 and 2018, but not the following years.

This means that the information for analysis cannot be properly filtered.

How can it be solved? Thank you

[v-yalanwu-msft]

Hi, @Syndicate_Admin ;

According to the offical document, When date ranges are very large, Google Analytics will return only a subset of values. You can use the process described in this section to understand what dates are being retrieved, and manually edit them. If you need more data, you can append multiple queries with different date ranges. If you're not sure you're getting back the data you expect to see.

Power Query Google Analytics connector - Power Query | Microsoft Learn

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.