Excel SharePoint Folder - Same files come in with different number of rows

[Anonymous]

I have a weird issue when trying to import multiple Excel files from a SharePoint folder. Each Excel file needs some manipulation to get just the data. For example, we need to delete the first 12 rows of each file and then promote headers.

The weird issue I'm getting is that for some reason there are a couple files that when they are brought into Power BI, they delete a row before any steps are performed? I've manually looked through every file and the data we want always starts on row 13. So removing the first 12 rows should work. However, there are a couple of files that the data starts on row 12 when brought into Power BI. I have no idea why this would be the case?

[v-lid-msft]

Hi @Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @Anonymous ,

It may because it apply a "promote as header" step between the "import excel file" and "delete the first 12 rows". Please go to Power Query Editor and try to check it in the "Applied steps" of issue tables. If there are such one extra step, please try to delete this step after make a backup copy pbix file.

Best regards,