Forum Discussion
Dynamic Source Name
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
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.
2 Replies
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.
Thank you MFelix ! that worked perfectly.
