Forum Discussion
DAX query results in brackets around column headers
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!
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. ✅
5 Replies
- anilelmastasi
Super User
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. ✅
- lbendlin
You cannot avoid the square brackets. Embrace them in your flow. Does it really matter if you use
item()['column']
or
item()['[column]']
?
v-prasareCommunity Support
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
