Forum Discussion

freelensia's avatar
freelensia
Icon for Advocate II rankAdvocate II
6 years ago
Solved

Insert a line break in the middle of Power Query text (not a text in Excel)

Hi,   I am building some "fake" queries to store instructions for my Power Query user. One might looke like this:   let MyText = "Instructions Welcome to the ... Step 1: ... Step 2: ... ..." i...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi freelensia 

    You could paste your test into one cell of an excel file, then load that table from excel with Power BI.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

rezaniroomand's avatar
rezaniroomand
New Member
4 years ago

Maybe too late to answer, but for anyone in future arriving here from Google:

These special strings are really handy:

  • Line feed: "#(lf)"
  • Carriage return: "#(cr)"
  • Tab: "#(tab)"

Also keep in mind that depending on the target OS that the text will be used in, dealing with line breaks can be slightly different. For example in Windows, it's usually CR + LF that you need to be safe in all apps (notepad anyone?), otherwise you may get away with a LF character.

PeterGyorgy's avatar
PeterGyorgy
Regular Visitor
3 years ago

Thanks, for me, this is The Solution.