Forum Discussion
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 se...
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!!
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?