Forum Discussion
Issue with Symbols
If I understand the documentation right, this is working as intended: "visual-specific formatting such as percent of grand total for a measure isn't preserved in Excel". I understand you're exporting via Power Automate but it's probably the same where exporting formatting is out of scope.
You might want to write an OfficeScripts in Excel (web version) that applies the $ formatting to your column, and trigger that script at the end of your Power Automate flow:
https://docs.microsoft.com/en-us/office/dev/scripts/develop/power-automate-integration
If you're looking for a no-code option, the Inforiver matrix custom visual does preserve formatting when exporting to Excel (disclosure: they're a consulting client of mine.)
If I understand the documentation right, this is working as intended: "visual-specific formatting such as percent of grand total for a measure isn't preserved in Excel". I understand you're exporting via Power Automate but it's probably the same where exporting formatting is out of scope.
You might want to write an OfficeScripts in Excel (web version) that applies the $ formatting to your column, and trigger that script at the end of your Power Automate flow:
https://docs.microsoft.com/en-us/office/dev/scripts/develop/power-automate-integration
If you're looking for a no-code option, the Inforiver matrix custom visual does preserve formatting when exporting to Excel (disclosure: they're a consulting client of mine.)