Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ncullen
New Member

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!

 

DAX Query Results.png

1 ACCEPTED SOLUTION
anilelmastasi
Super User
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.

View solution in original post

5 REPLIES 5
v-prasare
Community Support
Community 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
Community Support
Community 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
Community Support
Community 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

lbendlin
Super User
Super User

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

 

item()['column']

 

or 

 

item()['[column]']

 

?

anilelmastasi
Super User
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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.