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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
Gabe_V
Helper I
Helper I

Record.Field with underscore returns: "The name '_' wasn't recognized."

I am trying to remove a set of columns from a table by their index/position as opposed to the column name, because the column names can vary from month to month. I am using the code below, derived from a similar method I used before with the Table.AddColumn function (with no issues), but now when I try to use it in the Table.RemoveColumns function I get this error: "Expression.Error: The name '_' wasn't recognized. Make sure it's spelled correctly." Can anyone help explain why the underscore doesn't work in this instance, and what I should use instead? Thanks in advance!

 

#"Removed Columns1" = Table.RemoveColumns(
Source,
{
each Record.Field(_, Table.ColumnNames(Source){12}),
Record.Field(_, Table.ColumnNames(Source){14}),
Record.Field(_, Table.ColumnNames(Source){16})
},
MissingField.Ignore
)

 

 

1 ACCEPTED SOLUTION
ppm1
Solution Sage
Solution Sage

Try this instead:

 

#"Removed Columns1" = Table.RemoveColumns(
Source,
{
Table.ColumnNames(Source){12},
Table.ColumnNames(Source){14},
Table.ColumnNames(Source){16}
},
MissingField.Ignore
)

 

Pat

Microsoft Employee

View solution in original post

2 REPLIES 2
ppm1
Solution Sage
Solution Sage

Try this instead:

 

#"Removed Columns1" = Table.RemoveColumns(
Source,
{
Table.ColumnNames(Source){12},
Table.ColumnNames(Source){14},
Table.ColumnNames(Source){16}
},
MissingField.Ignore
)

 

Pat

Microsoft Employee

Well how about that! It works perfectly! However, it does kind of make me wonder why the Record.Field was needed in my previous Table.AddColumn query, because I had initially tried that one with just using Table.ColumnNames and it failed. I suppose that musing is for another day though. Thank you so much for your quick help! Cheers!

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors