Forum Discussion

DagmaraG's avatar
DagmaraG
Frequent Visitor
3 years ago

Power Query importing csv file with quatation as a joined delimeter

Hello,

I have some csv file I need to import to Power Query into Power BI.

 

Sometimes if in one field there is a combines artists It has a "artist1, artist 2" sign.
but when I try to load it to Power Query his gives me error and do not see it as a value.

Please look at screenshots

 

Need Help
Show and Tell

2 Replies

  • vicky_'s avatar
    vicky_
    Icon for Super User rankSuper User
    3 years ago

    Check the formula bar, specifically, the part that says Quotestyle, and change to QuoteStyle.Csv if it's like the one above.