Forum Discussion

mork's avatar
mork
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...
Need Help
mork's avatar
mork
Helper V
10 years ago

My gut tells me the right special characters are #(cr)#(lf) but they don't work at the moment.

 

Greg_Deckler Do you have a workaround maybe? A way to better show text without line breaks?

FawadRehman's avatar
FawadRehman
Helper I
10 years ago

I have been trying to use all the solutions available on the net but still no luck. Any Help from power BI guys? 

 

Full Contact = LOOKUPVALUE(' Contacts'[Manager Name],' Contacts'[Id],'Customer Contact'[ ContactId])
& " " & LOOKUPVALUE(' Contacts'[Email],' Contacts'[Id],'Customer Contact'[ ContactId])
& " " & LOOKUPVALUE(' Contacts'[Telephone],' Contacts'[Id],'Customer Contact'[ ContactId])

 

here's my code. 

  • sornavoor's avatar
    sornavoor
    Resolver I
    10 years ago

    Suggest that you raise it as a bug for the data import team to look at - at their leisure.  we are able to see the line break in the text  when looking at the data in Advanced editor .... but does not seem to get into the table from there :smileysad:  Thinking pacman is eating them up! 

    • mork's avatar
      mork
      Helper V
      10 years ago

      I have already submitted a ticket. still no reply.

      • Vicky_Song's avatar
        Vicky_Song
        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.