Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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?

Need Help

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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's avatar
        michaelbilling
        Helper II
        7 years ago

        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