Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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: ...
..."
in MyText
But Power Query does not let me have these line breaks. I have also tried.
let
MyText = "Instructions" & #(lf) &
Welcome to the ..."
in MyText
and:
let
MyText = "Instructions" & unichar(10) &
Welcome to the ..."
in MyText
Any ideas guys?
Solved! Go to Solution.
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.
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.
Never mind. I solved it with.
& Character.FromNumber(10)&
Pretty annoying to have to insert this at the end of every line. Plus if I have the double quotation mark in the text I must replace it with & Character.FromNumber(34) &.
Any other ideas?
The "& Character.FromNumber(10) &" works. The "#(lf)" does not seem to work in actual query strings (it simply gives an error looking for a token). The "Use Excel instead of Power Query" answer did not address the original issue at all. Thanks, freelensia, for following through and finding a solution that works.
Maybe too late to answer, but for anyone in future arriving here from Google:
These special strings are really handy:
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.
Thanks, for me, this is The Solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.