Dataflows power query editor does not keep formatting, line breaks or comments upon saving

[vvillama]

Hi,

We work a lot with dataflows and there's been something done to the query editor there that is quite annoying.

We create M code, sometimes with line breaks within steps to ease the code understanding, and sometimes we add comments to keep track of what's being done, sometimes before the let statement, sometimes after the code, sometimes in between...

This is not an issue on the desktop, anything you write there, stays. However, in dataflows' power query editor, upon saving it changes everything, comments and line breaks within steps are sistematically removed.

Could this please be reviewed so that the power query editor in dataflows does not modify the code by itself?

Thanks in advance, best regards.

[v-qiuyu-msft]

Hi @vvillama, 

The same issue has been reported by another user, you can take a look at this same thread: 

https://community.powerbi.com/t5/Issues/Bug-Incompatibility-in-Comments-Between-Power-BI-Desktop-and...

Best Regards,
Qiuyun Yu

[Anonymous]

Hello,

is this problem solved? I still experienced in 2022 that the advanced editor changes the formatting of the code.

Best Regads,