Excel File Name in a Custom Column

[newpbiuser01]

Hello,

I have a report that pulls data from multiple excel files from a folder. The excel file names have data that we'd like to use in the report. Just wondering how to do that using a custom column within power query? How do we get the excel file name as a calculated column within the data table? I'd really appreciate any help. 

Thank you!

[Anonymous · Accepted solution]

Hey in this case, you can choose Get data > Folder, once you choose folder, you will see all excel files name in your PQ. then you can do some data cleaning process to shape the data as the format you want in the report. Hope it is helpful! 

[newpbiuser01]

Thanks! I found it under the Source.Names column when I combined the files after loading 🙂