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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
smann
Helper I
Helper I

Can I refer to Table using String?

Here's what I tried to do that didn't work.

 

Replace this:

 

NewTable=#"MyTable"

 

With this:

 

TableName = "MyTable"

 

NewTable = #TableName

 

Is there something I can do along these lines? Thanks!

1 ACCEPTED SOLUTION
MarcelBeug
Community Champion
Community Champion

What I had in mind is to create a record for all tables you want to reference.

 

Query MyTables:

 

= [My Table = #"My Table", table1 = table1, table2 = table2]

The function that returns the table based on the name of the table:

 

 

= (table as text) as table => Expression.Evaluate(table,MyTables)

 

But why don't you just reference the tables as table? It's quit rare to reference a table by the name of the table.,

Specializing in Power Query Formula Language (M)

View solution in original post

5 REPLIES 5
MarcelBeug
Community Champion
Community Champion

As far as I know this can't be done directly.

 

A workaround is to create a record with the table(s) you want to reference.

This record can then be used as so called "Environment" wit function Expression.Evaluate.

 

Query MyTables creates a record:

 

= [My Table = #"My Table"]

 

Query in which the table is referenced:

 

let
    Source = "#""My Table""",
    NewTable = Expression.Evaluate(Source, MyTables)
in
    NewTable
Specializing in Power Query Formula Language (M)

thanks for the reply @MarcelBeug

 

I didn't quite follow what you said (very new to power query and rusty on this stuff in general), but I think I got the gist. I made a function that takes a string and returns a table based on a bunch of if statements (e.g. if string="table1" then #"table1" else if string="table2" then #"table2" etc).

 

let me know if that's what you had in mind. it's working so far as a workaround

MarcelBeug
Community Champion
Community Champion

What I had in mind is to create a record for all tables you want to reference.

 

Query MyTables:

 

= [My Table = #"My Table", table1 = table1, table2 = table2]

The function that returns the table based on the name of the table:

 

 

= (table as text) as table => Expression.Evaluate(table,MyTables)

 

But why don't you just reference the tables as table? It's quit rare to reference a table by the name of the table.,

Specializing in Power Query Formula Language (M)

@MarcelBeug got it, thanks. It's a very specific situation: I want to pull in a table from a csv and use that to check values in various tables. So one of the columns from the csv is the table name. To automate it, I want to use that column to refer to my tables rather than hard-coding for each table

MarcelBeug
Community Champion
Community Champion

Thanks for clarifying the context. Well appreciated

Specializing in Power Query Formula Language (M)

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.