Power Query - Importing Data from Folder

I need small explanation.

When I’m importing data from folder ( there are two excel files which contains sales data for each individual month August and July). When I try to combine both files and load to excel as table I am receiving the following error: The key didn’t match any rows in the table.

In order to fix this issue what I am following those steps https://www.youtube.com/watch?v=a7E29H5ZUmE&t=180s: go to transform data: select on content column and remove other columns, once that is done, then add custom column = Excel.Workbook([Content])

Next step is to remove the content column and expand the custom table.
After that, I select custom data table and I remove other columns. Once this is done I can expand data and promote first row as headers.

Is there any other way to transform data, just by pressing on two arrows on content and transform somehow the data? If this is not clear I’m happy to share my file.

Is double arrow only works if the file is save as txt or csv basically the file is a text file and if the file are saved as excel I need add extra column using Excel.Workbook???

Hi Matty,

Can you please share a (sample) file?


Hi uriah,

No need,I manage to get explanation by https://www.youtube.com/watch?v=ldoQws7Zbx8 (10 minute). To get object from excel files you need to add extra column using Excel.Workbook formula.

Hi Matty,

I am glad you have found a way to do it🙂