Forum Discussion

pabeader's avatar
pabeader
Icon for Post Patron rankPost Patron
5 years ago
Solved

Is there a way to expose the table name in Power Query?

I have 50+ tables that I need to include the name of, as a column in the table.  I would rather not go the 'add a custom column with the name of the table '  route.   I thought there would be someth...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    As lbendlin mentioned, the key is to use #shared in your query.  Here is some M code to give you a list of tables in the current model.

    let
    Source = #shared,
    #"Converted to Table" = Record.ToTable(Source),
    #"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each Value.Is([Value], Table.Type)),
    #"Filtered Rows" = Table.SelectRows(#"Added Custom", each ([Custom] = true))
    in
    #"Filtered Rows"

     

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

As lbendlin mentioned, the key is to use #shared in your query.  Here is some M code to give you a list of tables in the current model.

let
Source = #shared,
#"Converted to Table" = Record.ToTable(Source),
#"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each Value.Is([Value], Table.Type)),
#"Filtered Rows" = Table.SelectRows(#"Added Custom", each ([Custom] = true))
in
#"Filtered Rows"

 

Pat