Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to select multiple columns by using column index numbers (instead of names) however below row throws an error ("Expression.SyntaxError: Token '}' expected.")
= Table.ColumnNames(#"Renamed Columns1"){2,3}
I expec from Table.ColumnNames to return names of the columns and select columns function to select only these columns.
= Table.SelectColumns(#"Renamed Columns1", Table.ColumnNames(#"Renamed Columns1"){2,3})
I do not understand why it gives such an error because above rows works pefectly fine with single column index.
Is there any tip or shortcut for that? Thanks.
Solved! Go to Solution.
"I do not understand why it gives such an error because above rows works pefectly fine with single column index" - You can refer to one item of a list by index. For more than one item you need to use List functions e.g. List.Range or List.Combine or something else
"I do not understand why it gives such an error because above rows works pefectly fine with single column index" - You can refer to one item of a list by index. For more than one item you need to use List functions e.g. List.Range or List.Combine or something else
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
69 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
127 | |
29 | |
27 | |
24 | |
22 |