DataFlow function converted to text

[stewartfiserv]

If while editing a function I switch focus to another window my function is converted to text.

This:

Table.AddColumn(AddedIsWorkday, "Capacity", each [IsWorkDay] = true then 6 else 0)

Becomes this:

#!"Table.AddColumn(AddedIsWorkday, ""Capacity"", each [IsWorkDay] = true then 6 else 0)"

I understand this is because of an error in the formula but it is making the online editor almost unusable.

[v-danhe-msft]

Hi @stewartfiserv ,

I could not understand what is your desired result. Based on my test, you could use advanced editor in data flow to convert to text:

Regards,

Daniel He

[stewartfiserv]

Its not about what I'm trying to do in the advanced editor. Its the fact that when I am editing in the function window and change focus outside of the function window (like alt-tab to another app to reference some information) it destroys the function I was working on.

This function that I am working on that is partially finished:

Table.AddColumn(AddedIsWorkday, "Capacity", each [IsWorkDay] = true then 6 else 0)

Becomes this:

#!"Table.AddColumn(AddedIsWorkday, ""Capacity"", each [IsWorkDay] = true then 6 else 0)"

I then have to remove the #!" and all the double quotes to continue editing the function.

To recreate this:  Select a step, edit it to a partial non-compilable state, alt tab to another application (like you do when trying to read up on an M function) then alt tab back to Power Query.  Your partially completed function is convereted to a mess.