Solved: Strange Quotation in Exported CSV

Anonymous · ‎07-06-2020

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?

amitchandak · ‎07-07-2020

@Anonymous , If you are sure it is because of the jun version, please log an issue.

https://community.powerbi.com/t5/Issues/idb-p/Issues

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

amitchandak · ‎07-06-2020

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Anonymous · ‎07-07-2020

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.

amitchandak · ‎07-07-2020

@Anonymous , If you are sure it is because of the jun version, please log an issue.

https://community.powerbi.com/t5/Issues/idb-p/Issues

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here