Forum Discussion
mengsheng
Aug 26, 2019Copper Contributor
Can I keep the file name column when Combine files in a folder with Power query?
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 ?
SergeiBaklan
Aug 26, 2019Diamond Contributor
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.
mengsheng
Aug 27, 2019Copper Contributor
SergeiBaklanThank 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.