Forum Discussion
Import Data From Google Analytics
I want to get data from Google Analytics for last 30 days or even a year. But my GA account has a lot of data. (For example, I have 600,000 rows for just 5 days.) This is my query: let Source ...
Gracie,
There isn't a row limitation in Power BI Desktop. Power BI Desktop request all of the data that Google Analytics API returns, however, the underlying data Google Analytics API returns is itself sampled, you can review the blog to get more details.
You can follow the guide in this blog to break your large data range into multiple smaller date ranges and queries to avoid sampling, then connect to the data in Power BI Desktop.
Regards,
Lydia