Forum Discussion

Helper V

10 years ago

New line Characters

Hello, I use an excel file to import some text notes into Power BI for our departments. The notes are around two paragraphs and the show fine on excel. When importing them to Power BI they appear a...

Helper V

10 years ago

I have already submitted a ticket. still no reply.

Impactful Individual

10 years ago

mork, sornavoor, FawadRehman, Greg_Deckler, thanks for reporting this issue. I can reproduce the issue as well, I will report it internally and will post back once I get any updates.

mork
Helper V
10 years ago
Vicky_Song Thank you for reporting it. hopefully we will get a fix soon! And a better way to present text in power bi too.
- FawadRehman
  Helper I
  10 years ago
  mork any update on line break character ? we really need this option in our reports. Thanks
  - arify
    Microsoft Employee
    10 years ago
    We know about this issue, we've recently implemented a fix that takes <br> tags as new line. We aren't doing the change for <p> tags *yet*, because that will break the backwards compatibility (lot more than handling <br> tags :) ) This fix will be in the next or 2nd next PowerBI Desktop release.
    
    If you don't want to wait for that, I've suggested a workaround here: https://social.technet.microsoft.com/Forums/en-US/4c7b662d-2cb2-4d00-a1aa-da4f086ac984/powerquery-split-collumn-by-crlf-problems?forum=powerquery
    Basically, depending on your scenario, you can replace the <br> or <p> characters with a special character, then handle it that way.

Related content