Forum Discussion
Row limit with google analytics direct connection
Im currently trying to load information directly from google analitycs but im not being able to load more than 999,999 rows. is there a way to esceed this limitation?
Hi Anonymous
Do you connect to google analytics with Power BI Desktop or Service?
If you use Power BI Desktop,it could be a limitation in Power BI currently.
you could use parameter or M to filter rows.
Here is a similar thread you mat refer to.
Best Regards
Maggie
yes, im using the direct connector
the thing is that the information i want is about 5M rows and i dont want to filter it. im currently having to segment the query 6 times and append it but its really time exhausting
Anonymous v-juanli-msft
You can solve this by getting you Google Analytics data loaded into e.g. BigQuery or another online massive scalable db.
Normally this would demand buying Google Analytics 360, but you have another option, take a look at scitylana