Can I keep the file name column when Combine files in a folder with Power query?

Occasional Contributor


When I click into the binary content, I will lose the file name column, like the picture below. What can I do to  keep the file name column ? 



2 Replies


If you click on Combine Files on entire table like this


From Folder connector shall keep file names, like


If you keep only Content and Name columns result will be without filenames.

@Sergei BaklanThank you for your help. I really can't figure out how to Combine Files on entire table, the file name column will  still be lost if I  didn't delete other columns... I'm using power query built in excel, not Power bi.