Row limit with google analytics direct connection

[Anonymous]

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?

[v-juanli-msft]

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.

Get limited data in Power BI.

Best Regards

Maggie

[Anonymous]

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 

[michaelbilling]

@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