Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Copy / paste from Power Query in Power BI Desktop to Power Query in Power BI Service

Hi, when I copy a string containing line breaks from Power Query in Power BI Desktop to Power Query in Power BI Service, I get all line breaks replaced with (#CR) and/or (#LF). Why does this happen, ...
Dataflow
Need Help
ibarrau's avatar
ibarrau
Super User
5 years ago

This might sound crazy but I think I have seen this issue when you are writing the blank query, the whole script is not correct (it has a syntax error or something like that) and you click the Ok or accept button. Then the engine breaks the line break with the hidden code for that like (#cf).
Be sure to copy, paste and finish the blank query with the Let and the In completely before closing the advanced editor. If it fails, it breaks.

Hope that make sense. It's not the best approach I know 😞

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This issue seems to alway happen, blank query, syntax error or not:

 

 

  • ibarrau's avatar
    ibarrau
    Super User
    5 years ago

    It looks like a new expected behavior 😞

    I'm sorry but I don't think you can get rid of that addition in dataflows. You can suggest an idea about this:
    https://ideas.powerbi.com/

    You can also try opening a ticket but I think they won't say that there is an error there.

    Regards,