Forum Discussion

Isambard's avatar
Isambard
Icon for Helper I rankHelper I
2 years ago
Solved

Power Query Custom Column with Data Source

Hi,   I'm hoping this is really easy for someone with more experience than me. I'm taking data from a few dozen excel spreadsheets, each with a 20 named tables. I have set this up in power query an...
Need Help
  • Minseven07's avatar
    Minseven07
    2 years ago

    I see. Can you get your data in a folder then filter on that specific excel file? If yes, you will have access to the folder path and the file name.

     

     

kleigh's avatar
kleigh
Icon for Responsive Resident rankResponsive Resident
2 years ago

The name of the Excel file doesn't come at the step of Excel.Workbook, it's one before when you have your folder of Excel files. I think the usual thing is to combine by drilling into the Binary column, but it's also possible to create a new custom column with Excel.Workbook([Content]), remove the file information you don't need (including the raw Content), then expand your custom column. You'll also need to expand and combine your Excel tables in a way that preserves the file information as a column.