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
arify's avatar
arify
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Hi Johnnyg, when I checked it, at first it looked like one line, but the new line character is actually still there. What visualization are you using? Can you try to expand the size of the row vertically?

Johnnyg's avatar
Johnnyg
Frequent Visitor
10 years ago

I have used a couple with the same results: LongTextViewer,  Table (standard with PowerBI).

 

The field value in Query Editor displays:

Edward

Jones

 

The Data Views displays:

Edward Jones

 

The Visuals (both) displays:

Edward Jones        (independent of the column/field width.

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

    Can you please send a frown with that, and make sure you include the information in your last message (and maybe a link to this thread)?

     

    Thanks

  • Johnnyg's avatar
    Johnnyg
    Frequent Visitor
    10 years ago

    Done...Thanks!