- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Text strings creates additional lines in csv extract
Hello,
I'm using power bi to merge multiple tables which one of them include some text manually entered coming from an excel sheet. On the excel sheet, we may have:
"02/03: Update from OEM
24/02: checking stock"
Which means, each lines are returned to a new line using alt-Enter
I created a table in power bi, which shows the excel text info (see column remarks).
In power BI, the column remark appears correctly. However, when I extract the data, the csv file return all info on the first line, and then adds a new line for all lines that were returned to a new line in the original excel sheet.
Sorry, quite complex to explain, hope the pictures help.
How can I do to avoid that the lines are returned to a new cell ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @FannyZ
Can you provide the expected result you want or the sample expected result?
I'm a little confused by the problem you're described, do you mean you want to split the yellow parts of this image into each line?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello,
Thank you for trying to help. At the end, I solved the issue by removing every returned line in my excel data based.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I found a simple solution to this problem. When reading the csv in power pivot, the QuoteStyle parameter of the Csv.Document function will determine whether newlines within a cell force the rest of the cell onto a new line or not. I changed this parameter from QuoteStyle.None to QuoteStyle.Csv and the issue was resolved.
I figured this out using the documentation for the Csv.Document function: Power Query Guide - Csv.Document.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hello,
Thank you for trying to help. At the end, I solved the issue by removing every returned line in my excel data based.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @FannyZ
Can you provide the expected result you want or the sample expected result?
I'm a little confused by the problem you're described, do you mean you want to split the yellow parts of this image into each line?
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
10-04-2024 03:32 AM | |||
09-06-2023 05:16 PM | |||
04-05-2018 09:52 AM | |||
09-04-2024 11:19 PM | |||
01-23-2024 04:31 AM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |