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
FawadRehman's avatar
FawadRehman
Icon for Helper I rankHelper 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
Icon for Resolver I rankResolver 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
    Icon for Helper V rankHelper V
    10 years ago

    I have already submitted a ticket. still no reply.

    • Vicky_Song's avatar
      Vicky_Song
      Icon for Impactful Individual rankImpactful 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's avatar
        mork
        Icon for Helper V rankHelper 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.