#lf coming instead of linespace in advance query editor

[Shreenav]

I am copying a query from my Kusto explorer and then importing data from kusto in powerbi using direct query. After importing, in my dashboard data pane, when I choose edit query for any query and select advance editor, then in the advance editor #lf comes instead of the whitespaces in my query. I tried copying the query from notepad and any online editor but still the issue persists. Please help.

[Idrissshatila]

Hello @Shreenav ,

can you show us the issue please?

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

[Shreenav]

instead of #lf, I want to see linespace here. In the query in Kusto explorer, I have linespace and when I import I just paste the query from kusto explorer to power bi, but when I open it in the advance editor, it shows #lf instead of linespace.

[Anonymous]

Hi @Shreenav ,

Try copying the query code into notepad and if it still shows #(lf), try searching to replace it.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum