Forum Discussion
Post PatronIs 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 something like Table.Name that I could use, but I sure can't find it.
This doesn't work:
Text.Combine({Text.From([EAREA], "en-US"), Text.From([ENUMBER], "en-US"),Text.From([Table.Name], "en-US")}, "-")
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
4 Replies
- mahoneypat
Microsoft Employee
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
- lbendlin
Super User
ImkeF has answered that question a while back.
Is there a way to get a table name in Power Query? (microsoft.com)
pabeaderI read that and that is exactly what I don't want to do. Assume that I have no idea what the table names are going to be. I need some way to get the table name from the object itself.
- Icey
Community Support
Hi pabeader ,
Please check if the method mahoneypat provided could meet your requirements.
And this blog explains in detail: Get List of Queries in Power BI - RADACAD.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
