Power Query Data Loding Issue

Question

Hi All,

I have created a query which load the data from folder from multiple file and tab. What I notice is that one of the tab is not getting loaded completely. There are 16 rows wherein excel loads only 6 line. I am missing on the 10 lines of data.

]2

Need help to understand what is causing this issue.

However I have tried to load the data from excel file directly this is where excel is extracting complete data from the file without any miss.