Forum Discussion

ALRUYOYO's avatar
ALRUYOYO
Icon for Advocate I rankAdvocate I
9 years ago

How to write quotation marks to get a single quotation mark when exported to csv?

Hey, I am struggling to find a solution maybe someone can help. In power BI I see the result I need where text is inside SINGLE quotation marks and separated by a comma, but when I export it ...
Need Help
Show and Tell
Tips and Tricks
Reid_Havens's avatar
Reid_Havens
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago

Ah good clarification, thanks Phil. The export to csv definitely adds an extra layer of logic that needs to be accounted for. It's a great question, I'll noodle on this a bit since now I'm curious if there's a way to do this without too much heavy lifting.

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

If the objective is to extract data out of Power BI, then here is one option

 

http://powerbi-pro.com/export-data-to-sql/

 

It uses an R Visual to export to an SQL DB, but you can probably modify it to write to a flat file as an option.  An R visual will export the data relevant to the currently selected filters too.