Create excel report

Hi  Sonashish ,

Based on my test,as you have different sheet names for each .xlsx file,which causes the error below:

If you have different sheet names,it would be hard for power query to  identify the row in the table that contains the data you want to see.That is why you see the error.The only solution is to modify all the sheet names to the same one,such as "Sheet 1":

Source{[Item="Sheet1",Kind="Sheet"]}[Data]

Below blog has detailed explanation you may refer to :

https://blog.crossjoin.co.uk/2020/04/06/understanding-the-the-key-didnt-match-any-rows-in-the-table-error-in-power-query-in-power-bi-or-excel/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Hello Kelly,

That is what I mentioned that if you are combining excel files, so all the excel file sheet name should be same,  surprisibgly it case sensitive as well. So in all excel sheet name should be in same case.

I saw the blog you mentioned, but it should also mention in Microsoft site as well.

Thanks for confirmation.

Sona