cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate III
Advocate III

Export to Csv has formatting issue for the negative numbers

Hello,

Is there any workaround for the below mentioned issue.

 

My data has both positive and negative numbers. When i export the data to csv in desktop, the number formatting is fine.

But the export to csv from the service, is converting negative numbers to text format and the postive numbers are in the number format (both from the same column).

Not sure if it is a bug. Can someone help, please.

 

Thanks,

Soumya

9 REPLIES 9
Highlighted
Super User IV
Super User IV

Re: Export to Csv has formatting issue for the negative numbers

Hi there

It would appear to me to be a possible bug.

Just to confirm that your data type on the column is set to a number format?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
Microsoft
Microsoft

Re: Export to Csv has formatting issue for the negative numbers

Hi @SoumyaPuppala ,

Based on my test, it could not be a bug but a limitation of exporting to csv file, plesase consider this limitation:

When exporting to .csv certain characters will be escaped with a leading '.

In my environment, both of exporting to csv files are the same in power bi desktop and power bi service. The negative numbers will have a ' leading in the csv file, after you click the specific number in the formula bar of the column, it will have an error warning like this:

csv.png

The negative numbers are stored as text and you can convert them to number and save it normally.

 

Best Regards,
Yingjie Li

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

Highlighted
Advocate III
Advocate III

Re: Export to Csv has formatting issue for the negative numbers

I could not replicate this issue when exporting to csv from desktop. It is only occuring when exporting from desktop.

Highlighted
Regular Visitor

Re: Export to Csv has formatting issue for the negative numbers

Same issue here, it just started happening and costing me a ton of time. It worked fine last month, has to be a bug...

Highlighted
Post Prodigy
Post Prodigy

Re: Export to Csv has formatting issue for the negative numbers

@Cpgbi 

If it worked last month and now it means that between now and then there was an update somewhere that caused the incompatibility. The newest version of Power bi desktop and the latest Microsoft Excel version should give the best result.

Regards
Amine Jerbi
https://www.linkedin.com/in/amine-jerbi-2b3a8928/

Did I answer your question? Mark my post as a solution!
Highlighted
Regular Visitor

Re: Export to Csv has formatting issue for the negative numbers

Hi , Did you get a solution to your issue, we are also facing the concern

Highlighted
Advocate III
Advocate III

Re: Export to Csv has formatting issue for the negative numbers

It looks like a similar issue has been reported and microsoft is working on the fix. 

Please find more details and future updates here - 

https://community.powerbi.com/t5/Issues/Export-to-CSV-from-service-is-converting-negative-values-to-...

Highlighted
New Member

Re: Export to Csv has formatting issue for the negative numbers

I was having the same problem, exporting negative numbers with Power BI Desktop to CSV, I was getting an ' (hyphen) at the beginning of each negative number. I uninstalled Power BI Desktop and reinstalled the previous version (May 2020 Update (2.81.5831.621) - https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive). Now it works. my suggestion is to use the previous version until the problem is not fixed.

Highlighted
Regular Visitor

Re: Export to Csv has formatting issue for the negative numbers

This is not an acceptable fix.  Not realistic in real world application. Users commonly export data to perform calculations on values.  Needs to be fixed ASAP.  It IS a bug.  It worked previously and now it is broken.

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors