cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

ignoring Line breaks within quotes while importing folder

Capture.PNG

 

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 , some of the CSV files have line break within quotes . I am able to take care of these while importing individual files since i have an option to Ignore line breaks within quotes ( as shown in the image)

 

While importing these files all at once from a "Folder"i dont get such an option . Without this , there is data getting shifted to a new line in some some places midway when all the files are getting imported . Anyone have any idea to tackel this ?

 

Thanks

MK

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

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:

 

Transform Sample query 2.png

 

Probably it's most convenient to apply the adjustments via the Advanced Editor.

Specializing in Power Query Formula Language (M)

View solution in original post

2 REPLIES 2
Highlighted
Community Champion
Community Champion

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:

 

Transform Sample query 2.png

 

Probably it's most convenient to apply the adjustments via the Advanced Editor.

Specializing in Power Query Formula Language (M)

View solution in original post

Highlighted

This is awesome ! Just how i wanted to work !! Thanks a lot 🙂

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors