Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Export to CSV from service, is converting negative values to text format

Submitted by Anonymous on ‎06-01-2020 02:04 PM

When i export the data to csv from 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. 

 

Thanks,

Soumya

Status: New
See more ideas labeled with:
29 Comments (29 New)
Comments
rcalderon
New Member
‎07-02-2020 11:37 AM

Same problem here. For me it started with June 2020 update in Power BI Desktop. Does anyone know a workaround while this bug is corrected?

 

Version: 2.82.5858.961 64-bit (junio de 2020)

 

rcalderon_0-1593715013090.png

 

Anonymous
Not applicable
‎07-02-2020 11:48 AM

For everyone wondering when a fix is coming, 

 

My experience with the support team and bugs like this is that they wait to roll it out with the next monthly release. Makes sense, since they're on that cadence anyways--why roll out a mid-month update just to hve everyone update to their next release as well? I would bank on them fixing this in the July update, which will likely be either next week or the week after.

 

This bug was reported in reverse (Service was exporting the apostrphe and not desktop) before the June update, and after the update they seem to have shifted the problem to Desktop somehow.

 

Of course, it would be nice to hear something from them instead of speculating..

dmacdonald
Advocate I
Advocate I
‎07-06-2020 06:33 AM

It's irritating.

 

A simple workaround is to open the csv file in Excel and then do a find and replace all

Find:  '-

Replace: -

 

This assumes that there are no text fields are supposed to start with a -

 

You could do it with your favorite scripting tool if you like.

 

 

 

 

Anonymous
Not applicable
‎07-07-2020 12:28 AM

Same with @Anonymous . This is very frustrating. The issue still exists in the latest version. Please fix ASAP

Annotation 2020-07-07 162158.jpg

pdelia
Advocate I
Advocate I
‎07-10-2020 04:52 PM

Can confirm I'm seeing this same problem with June 2020 Desktop release.

Anonymous
Not applicable
‎08-01-2020 09:14 PM

I need help please,

I have this problem whit my calendar I don`t know how fix it! do you have any advance for me ? bug power bi.PNG picture bellow bug pbi.PNG

amalagocki
Regular Visitor
‎07-07-2021 08:34 AM

I have this issue with just a "-" sign. Negative numbers are OK, but dash alone is preceded with apostrophe when exported to csv. Both in desktop and service.

Anonymous
Not applicable
‎09-02-2021 05:39 PM

This is also happening to me; when the dataset is imported as temp csv to use in an R visualisation 😞 

craigleach
Frequent Visitor
‎05-13-2022 12:25 PM

This is still a problem in May 2022!

Idea Statuses