Forum Discussion

mark_carlisle's avatar
mark_carlisle
Advocate IV
5 years ago
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 ...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    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

mark_carlisle's avatar
mark_carlisle
Advocate IV
5 years ago

That's the one.

 

Thanks for the help.

lbendlin's avatar
lbendlin
Super User
5 years ago

Please do let me know once you get the ADOmd to work. So far it errors out for me.