Power Query not identifying all rows from excel unless I resort in excel and save???

I have two excel files that are generated from an Alteryx workflow that obtains information from SAP. These two files are the only data source for a Power BI build. The refresh of these files happens daily before power bi refreshes the data for the reports. What i have noticed is that power bi is not displaying the same number of rows as the data source.  If i simply change the sort order of one column in the orginal file and save it then power bi will then magically see all the rows of data. I cannot manualy carry this out every day as the process is meant to be automatic. Why would power querry within power bi not identify all the rows of data unless I open the orginal data source and then effectively shuffle the rows and save. 

Anyone out there have a similar issue that is corrected by simply opening the original file and saving it???? I cannot see a solution to these missing rows suddenly becoming visable after only carrying out a sort in decending order....

Any help would be appreciated please. 🙂