retrieving source file name while using table combine

[duimdog]

I have a series of Excel files that I want to combine in Power Query. I don't want to use the helper queries, so I use Table.Combine(source[Data]) to combine the Tables in my Source step. Works fine.

But now I want to retrieve the name of the sourcefile the data comes from. 

I tried to add a new column to the individual tables by adding

List.Transform(
    Source[Data],
    (outer_table) => Table.AddColumn(outer_table,"SourceName", 
    each (Source[Name])))

but that generates a list of all the filenames instead of the individual filename of each file.

Anyone a suggestion how to fix this?

[duimdog]

I started all over and succeeded in replicating your example and with success!

Thank you for your solution!

[dufoq3]

You're welcome 😉

[duimdog]

Not (yet) succesfull: I get an error in the "Tbl" column, stating that "it cannot convert a value of type Binary to type List.

[dufoq3]

It is hard to help you without any screenshots, data etc...

[dufoq3 · Accepted solution]

Hi @duimdog, it is possible. With the highlighted part you transfer binary to table and the other part add new column with SourceName.