DAX query results in brackets around column headers

[ncullen]

Hello,

I am writing a DAX query to use in a Power Automate flow. I am testing the query in Power BI desktop before I deploy it using Power Automate. However, the resulting data has square brackets surrounding the column headers. I have clipped a small screenshot of the query, specifically where I rename the columns using "SELECTCOLUMNS()" and the resulting data. The rest of the data is not shown due to privacy. Any help is much appreciated in removing these brackets.

Thank you!

[v-prasare]

Hi @ncullen,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @ncullen,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @ncullen,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[lbendlin]

You cannot avoid the square brackets. Embrace them in your flow. Does it really matter if you use 

item()['column']

or 

item()['[column]']

?

[anilelmastasi · Accepted solution]

Hello @ncullen ,

DAX always returns columns as [ColumnName] format in the query editor or result pane. This is not something you can remove inside DAX itself.  When you consume the output in Power Automate, the brackets are not included in the JSON or parsed result — they are just metadata markers.

If this solved your issue, please mark it as the accepted solution. ✅