Forum Discussion

AdamTJ's avatar
AdamTJ
New Member
2 years ago

Only getting 20 000 rows

Hi!

I'm new at Power BI and trying to figure out why I only get 20 000 rows from my datasource. When reading the documentation I cant see any restrictions on amount of rows. Hovewer data import seems be limited by actuall size, but thats not the problem in my case.

 

Can anyone explain why I'm only getting 20 000 rows and is there a way to get more rows?
Thanks!

Need Help

4 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    Hello AdamTJ ,

     

    You can definitely get more than that, maybe in Power query there is a filter that is filtering your data and only getting this count.

     

    check your power query, do a count of rows inside power query and between steps to see which steps is making this change.

     

    check this https://youtu.be/0fN48V7fi3Q?si=wjRZr1VH_2vEGgaG

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos đź‘Ť

    Follow me on Linkedin
    Vote For my Ideađź’ˇ

     

    • AdamTJ's avatar
      AdamTJ
      New Member
      2 years ago

      Thank you for your response!
      I do have some filtering but only in the URL for the endpoint where im fetching the data. Thats the only filteraction, the other actions are related to changeing columname, reorder columns and add colums.

      The data I'm trying to fetch are transactions in a specific period, the dataset I'm getting is exactly 20 000 rows. However, if i change the filtering to only get for example 2023-07-01 to 2023-07-15 then the return dataset is about 19 000 rows. Then if I filter for 2023-07-16 to 2023-07-31 I get 19 000 more rows. 
      So the whole period is more then 20 000 rows.

      I can only conclude that Power BI only reads 20 000 rows from my data source, but I dont understand why?

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    2 years ago

    Hello AdamTJ , what is the data source that you are using?

     

    If it is SQL server check with the query in advanced setting of connection.

    Then also check or filters in Power Query and also Power BI Desktop as well. 

    IF there are no restrictions like that then there is no case that the data will be restricted. Check all filters and let us know if you still face issue. 

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

    • AdamTJ's avatar
      AdamTJ
      New Member
      2 years ago

      Thanks for the reply!
      Im using a web service, so data is fetch from an endpoint as a json file. Maybe thats restricteed to 20 000 rows?