Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Strange Quotation in Exported CSV

Hi,

 

Since June update, I get a single quotation mark in front of every negative number in exported CSV. This error has been replicated in another computer with newly installed Power BI Desktop. The screenshot is from a simple file with entered numbers in three different format. The CSV has the quaotation in all three columns.

 

Does anyone else has this problem?

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous ,

    Can you open the file in a text pad and check do you have '

    I doubt it is because data in excel is detected as Text, can you change it number and check

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Unfortunately, it's the same.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I can confirm this issue is caused by June update. I have two computers with May version initially. After I upgraded to June version on one of the computers, the problem emerged. I tested the same visual of the same file on the other computer with May version and didn't get the quotation marks. Then I upgraded the second computer to June and got the same problem. Then I installed June version on a third computer and got the same problem.