Dynamic Source Name

[amaniramahi]

I need to combine files in sharefolder.

Data are in one sheet, not fomatted as tables.

sheets names are different.

When I make the necessary transformation to combine only the sheets I want.

I click combine

I have to choose a paramete based on a sample file.

But When I do, the query gives an error.

An error occurred in the ‘Transform File’ query. Expression.Error: The key didn't match any rows in the table. Details: Key= Name=2021010293745 Table=[Table]

please help

[amaniramahi]

Thank you @MFelix ! that worked perfectly.

[MFelix · Accepted solution]

Hi @amaniramahi 

Check if this solution works for you:

https://radacad.com/get-data-from-multiple-excel-files-with-different-sheet-names-into-power-bi

This selectes each index of the sheet and not it's name, it has an example with a transformation file has you need.