Forum Discussion

newpbiuser01's avatar
newpbiuser01
Helper V
4 years ago
Solved

Excel File Name in a Custom Column

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!

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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! 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      newpbiuser01
      Helper V
      4 years ago

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