CSV from Sharepoint - Ignore quoted line breaks

[Nexans]

Hi.

I`ve figured out that I need to enable "ignore quoted line breaks" on CSV-import on the source I`ve got. Now I get the files automatically uploaded to a Sharepoint site, but adding a sharepoint folder I do not get the same option of ignoring line breaks.

Someone who knows about a work-around?

[v-frfei-msft · Accepted solution]

Hi @Nexans ,

To import 1 file with the options as indicated, next import the files from the folder and then adjust the relevant part of the generated code with the corresponding part of the code that was first generated for 1 file.

When importing files from a folder and combining them, you get several query objects.

The object that you should adjust is the query that transforms the example file, you can find at the location similar to this screenshot:

Please refer to this case.

https://community.powerbi.com/t5/Desktop/ignoring-Line-breaks-within-quotes-while-importing-folder/t...

[Nexans]

Thaks a lot. 

And for future reference, it ic changing from QuoteStyle=QuoteStyle.None to QuoteStyle=QuoteStyle.Csv in advanced editor.