Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
pabeader
Post Patron
Post Patron

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 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")}, "-")  

 

 

1 ACCEPTED SOLUTION
mahoneypat
Employee
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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

4 REPLIES 4
Icey
Community Support
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.

mahoneypat
Employee
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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


lbendlin
Super User
Super User

@ImkeF  has answered that question a while back.

 

Is there a way to get a table name in Power Query? (microsoft.com)

I 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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors