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.

     

     

Minseven07's avatar
Minseven07
Frequent Visitor
2 years ago

in your query editor, when you get your source file, you have access to the folder path and the file name. You can maybe concatenate those column.
If this doesn't help, a pbix file whould be welcome

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

    Thank you. I don't need the file path, just the name would be fine. But I'm not seeing an option to load either of them as collumns. Should this be in the window when I load the data?

     

    Sorry I can't post the pbix as its confidential but here are some screenshots:

    The data then loads with all the fields from the excel table but not the source name.

     

    Thank you.