Forum Discussion

mork's avatar
mork
Icon for Helper V rankHelper 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...
Need Help
Vicky_Song's avatar
Vicky_Song
Icon for Impactful Individual rankImpactful Individual
10 years ago

mork, please have a check on arify's solution to see whether it works. If you still need further help, please post back.

mork's avatar
mork
Icon for Helper V rankHelper V
10 years ago

Vicky_Song Unfrtunately arify's solution is for splitting columns and not for line feed.

  • arify's avatar
    arify
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    I think I've reproduced the issue, which turned out to be not an issue. Have you tried clicking those cells? Sometimes Excel shows multiple lines as one line, but when you click to that cell on the formula bar it shows it as multiple lines.