Forum Discussion
Solved
Removing square brackets from column headers DAX query
I'm attempting to streamline an extremely convoluted process developed by one of my colleagues that involves exporting data from a Power BI report, renaming various columns, then uploading the final ...
You're right. I see it too. How about this?
$Results | export-csv -Path $ExportPath -NoTypeInformation
(Get-Content -Path $ExportPath ) -replace '[\[\]]' | Set-Content -Path $ExportPath
When I run such a query in DAX Studio I don't get any square brackets in the output format. How are you piping the results of the query into your output file?