Forum Discussion
Solved
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...
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.