Forum Discussion
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, ...
Hi, I should have added a screen shot of the issue to explain it better. This is what I get when I press Ok in Advanced Editor with a SELECT statment containing line breaks in Power Query in a dataflow in Power BI Service:
It seems not to support regular linebreaks, but encodes them into #CR and #LF! So my question is: Is there any way to preserve normal line breaks in such a string in a dataflow in Power BI Service?
I had this same problem just now. Unsure if you managed to solve this but for myself, I've saved a dynamic date calendar table as code to paste into a Blank Query when starting a new project. This same error kept showing up until I added a "=" at the beginning of the code.