Forum Discussion

scabral's avatar
scabral
Icon for Helper IV rankHelper IV
4 years ago
Solved

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