Forum Discussion

Regular Visitor

4 years ago

Solved

Issue with Symbols

Hi All, I have created a flow to pull reports using Power BI and Power Automate. When I get the report on my onedrive (in excel), the symbols in my columns are missing. An example of this would b...

otravers
4 years ago
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.
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data?tabs=powerbi-desktop

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.)

Anonymous

Not applicable

4 years ago

Hi SC22 ,

You mentioned in your question that the symbols don't show up after the data is imported into power bi, where do you mean they don't show up?

I did a test myself and found that if I fix the data format in the excel file, the symbols are displayed properly in the report.

This is my testing data in excel, I fixed the data format of the “target” column to be “Currency”

And then I connect to this excel file through onedrive in power bi service. This is the dataset generated after the connection.

Use this dataset to create a report, I find that the symbol can be displayed normally.

I hope my testing process will be helpful to you.

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Related content