Forum Discussion
Only getting 20 000 rows
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💡
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?