Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Exporting a table adds apostrophe to negative values

Hi all,

I am using Power BI Desktop Version: 2.82.5858.641 64-bit (June 2020).

When I export table visuals in my report:

the CSV file creates an apostrophe infront of the negative values:

Work around is to find and replace ' with nothing but am I missing something fundamental here? Can I stop this happening to remove the replacement step?

Thanks

Anonymous
6 years ago
I have just come across this post referring to the same issue but in Power BI Service:

https://community.powerbi.com/t5/Service/Leading-apostrophe-is-added-to-negative-numbers-when-exporting/m-p/1142648#M98262

Which also refers to this issue to vote for:
https://community.powerbi.com/t5/Issues/Export-to-CSV-from-service-is-converting-negative-values-to-text/idc-p/1139107#M57586

I assume this is just a bug that may get fixed soon

1 Reply

Anonymous
Not applicable
6 years ago
I have just come across this post referring to the same issue but in Power BI Service:

https://community.powerbi.com/t5/Service/Leading-apostrophe-is-added-to-negative-numbers-when-exporting/m-p/1142648#M98262

Which also refers to this issue to vote for:
https://community.powerbi.com/t5/Issues/Export-to-CSV-from-service-is-converting-negative-values-to-text/idc-p/1139107#M57586

I assume this is just a bug that may get fixed soon