Forum Discussion
Solved
ignoring Line breaks within quotes while importing folder
Hello, i'm pretty new to power bi and I''m trying to import a folder with CSV files in it . The files are comma seperated and are enclosed with double quotes . From what i have observed ...
To be honest, I'm not familiair with these specific options, but I do have an idea.
I would try and 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:
Probably it's most convenient to apply the adjustments via the Advanced Editor.
I found in the Transform sample file you could apply the same step, 'Ignore quoted line breaks'. I am glad you found a solution.