The loaded file shows column and rows lesser than source (excel)

[anantmishra61]

I have loaded the file into my Power BI app, which had 105,300 rows in excel source. When loaded into Power BI, the number of rows loaded is 105,251. I have checked the Don't summarize option for the Personnel Id and other fields to load the complete data but it is not working. Can some one help me here.

[anantmishra61]

@PhilipTreacy  I rechecked on the issue and found the solution. Thank you for checking in.

[PhilipTreacy]

@anantmishra61 

and the problem/solution was ??

[anantmishra61 · Accepted solution]

@PhilipTreacy I checked the source datatype and the data values in them. I found some corrupt data the project was receiving from source team. I rectified them and resolved the issue. 

[PhilipTreacy]

@anantmishra61 

What filters are being applied in Power Query?

Phil