Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-822633%22%20slang%3D%22en-US%22%3ECan%20I%20keep%20the%20file%20name%20column%20when%20Combine%20files%20in%20a%20folder%20with%20Power%20query%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-822633%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128515iA5226FFD74A7BEE5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWhen%20I%20click%20into%20the%20binary%20content%2C%20I%20will%20lose%20the%20file%20name%20column%2C%20like%20the%20picture%20below.%20What%20can%20I%20do%20to%26nbsp%3B%20keep%20the%20file%20name%20column%20%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128516i0DE33654302F2801%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-822633%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-822808%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20keep%20the%20file%20name%20column%20when%20Combine%20files%20in%20a%20folder%20with%20Power%20query%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-822808%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398440%22%20target%3D%22_blank%22%3E%40mengsheng%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20click%20on%20Combine%20Files%20on%20entire%20table%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128527i8CAC96E0D930FE2E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EFrom%20Folder%20connector%20shall%20keep%20file%20names%2C%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20395px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128528iCD91AC47F2EC4381%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20you%20keep%20only%20Content%20and%20Name%20columns%20result%20will%20be%20without%20filenames.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-823772%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20keep%20the%20file%20name%20column%20when%20Combine%20files%20in%20a%20folder%20with%20Power%20query%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823772%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3EThank%20you%20for%20your%20help.%20I%20really%20can't%20figure%20out%20how%20to%20Combine%20Files%20on%20entire%20table%2C%20the%20file%20name%20column%20will%26nbsp%3B%20still%20be%20lost%20if%20I%26nbsp%3B%20didn't%20delete%20other%20columns...%20I'm%20using%20power%20query%20built%20in%20excel%2C%20not%20Power%20bi.%3C%2FP%3E%3C%2FLINGO-BODY%3E
mengsheng
Occasional Contributor

clipboard_image_0.png

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 ? 

 

clipboard_image_1.png

2 Replies

@mengsheng 

If you click on Combine Files on entire table like this

image.png

From Folder connector shall keep file names, like

image.png

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.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies