Forum Discussion
GA4 Connector doesn't work
Hi G_CR_23
Google Analytics APIs do have some limitations on the queries sent to them. When date ranges are very large, Google Analytics will return only a subset of values. You can use the process described in Troubleshooting section of the following documentation 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.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi Anonymous ,
ty so much, but my problem isn't that i obtain only a subset of data. I see data in power query, but when i click on close and apply, data start to loading and keep going forever. It happens when rows are more then 20k and it can depends not only from time range, but also for the number of dimensions that you need, because more dimensions = more rows and it seems that power bi can't load more than a certain numbers of rows.
Thanks so much!
Gianluca