Forum Discussion
Remove brackets from column names using Power Query
Hi,
i have a DAX query that I am using within the power query editor to bring in a table from an SSAS tabular server. Here the DAX query:
EVALUATE
SELECTCOLUMNS (
CALCULATETABLE (
'Client',
'Client'[Current Row Indicator] = "Y"
),
"Account Name", [Account Name],
"Account Number", [Account Number],
"Start Date", [Start Date]
)
When you run this in DAX studio or in SSMS, the columns come back without any brackets. Howerver, in Power Query, brackets are coming back around the column names like [Account Name]. I don't think there is a way around it using DAX syntax as I already did a selectcolumns to try and get rid of the brackets. Is there a way in Power Query to go through each column name and remove the brackets?
thanks
Scott
There are a couple of solutions to this given here:
https://community.powerbi.com/t5/Power-Query/Bulk-Renaming-column-in-PQ-with-a-pattern/m-p/2289893
2 Replies
- AlexisOlson
Super User
There are a couple of solutions to this given here:
https://community.powerbi.com/t5/Power-Query/Bulk-Renaming-column-in-PQ-with-a-pattern/m-p/2289893- scabral
Helper IV
Thank you AlexisOlson , this worked perfect!
I was able to create a separate function to parse the column names using your script.