row limintation

bi_user01 , you should be able to analyze that. There is a limitation on the size with version and direct query has 1M rows limitation for one query

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-manage-your-data-storage-in-power-bi

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-data-points

https://community.powerbi.com/t5/Desktop/Power-BI-10-000-rows-limit-Question/td-p/17715