topic BUG::Power Query Advanced editor in Dataflow

BUG::Power Query Advanced editor

Element115 — Wed, 24 Jan 2024 22:29:15 GMT

(for those wondering why I am doing this, it is because this query feeds into the next one and because I just deleted the respective table in the lakehouse and the mode is 'Append', this first query expects to find a table that is not empty in the lakehouse. Therefore the idea was to uncomment everything instead of deleting the query (since it does not seem possible to deactivate the query without deleting it) so that the second query would run in 'Append' mode and create the table anew and repopulate it without having to click on the Data destination settings and changing 'Append' to 'Create new table' and then coming back in and switching it back to 'Append' mode. But I get a feeling I will end up to have to do so anyway.)

STEPS:

0__create a Dataflow Gen2

1__create any query in M

2__select all the lines and CTRL-/ to comment out all the code

3__click OK

4__error message: Token Literal expected appears, and a red tilda symbol at the end of the line of the last line that is commented out

see screenshot here:

Re: BUG::Power Query Advanced editor

frithjof_v — Wed, 24 Jan 2024 23:30:15 GMT

I think it expects at least a let statement and an in statement. You could write something like

let

Source = ""

Source

I thought if you disable the staging of the query, and also make sure the query does not have a destination and is not being referenced by another query, then I thought that would "deactivate" the query but I'm not sure it's just a guess tbh

Re: BUG::Power Query Advanced editor

Element115 — Wed, 24 Jan 2024 23:46:35 GMT

Yes, you're right. Thank you.