Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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. ✅
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
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
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
You cannot avoid the square brackets. Embrace them in your flow. Does it really matter if you use
item()['column']
or
item()['[column]']
?
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. ✅
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |