Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Line Break - CSV Files

Hi, 

 

I was trying to combine multiple CSV files, but I got the error that I have a column named "Comments" that actually is Long text where our customers provides feedback, my challenge is that everytime a customer used a line break, this made that Power Query Reads a new Row, instead of leaving all the information together on the last column named "Comments" 

 

I have tried already cleaning data with Trim and Cleaning Format options, but it does not work and still leaves the new Row only with the text due to the Line Break. 

 

Is there any way I can avoid this? Appreciate your help. 

 

Regards, 

 

MIchael Pinto. 

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @Anonymous 

 

It’s my pleasure to answer for you.

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 the option at the location similar to this screenshot:

v-janeyg-msft_1-1602570706927.png

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
sarathD4s
Frequent Visitor

Hi @CNENFRNL , 

i am having the same issue and i tried to do the steps you said but i couldnt find that option.

I am loading all the files in a folder and combining it and tried double clicking the sorce and it is just showing the folder path, is there any other way to sort this issue

v-janeyg-msft
Community Support
Community Support

Hi, @Anonymous 

 

It’s my pleasure to answer for you.

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 the option at the location similar to this screenshot:

v-janeyg-msft_1-1602570706927.png

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Did you enable Line breaks as ignore quoted line breaks on CSV-import on the source 

Capture.PNG

Appreciate your kudos!! Mark my post as solution if this helps.

This is exactly what I needed. Thank you NikhilKumar.

Anonymous
Not applicable

Hello! Thanks for your quick answer, I have been looking for something for the past 7 hours. 

 

Just wondering, where can I pull out that menu? I am using my power Bi Desktop but when I loaded all the CSV files, it does not show me those options. Also, I tried to use the Option Change Source and Data Source Settings but it does not show that.

 

MichaelP8989_0-1602561997206.png

 

 

What do I have to do to find that option? 

Anonymous
Not applicable

@Anonymous -You will find that menu once you click settings button on Source in Applied Steps section.

Appreciate your kudos!! Mark my post as solution if this helps.

Hi, @Anonymous , try to double click the Source step in the APPLIED STEPS area then that menu pops up

Untitled.png

 


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors