Remove brackets from column names using Power Query

[scabral]

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

[AlexisOlson · Accepted solution]

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]

Thank you @AlexisOlson , this worked perfect!

I was able to create a separate function to parse the column names using your script.