Forum Discussion

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
2 years ago
Solved

BUG::Power Query Advanced editor

(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 ...
Dataflows
  • frithjof_v's avatar
    frithjof_v
    2 years ago

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

     

    let

    Source = ""

    in

    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

frithjof_v's avatar
frithjof_v
Icon for Community Champion rankCommunity Champion
2 years ago

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

 

let

Source = ""

in

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

Element115's avatar
Element115
Icon for Memorable Member rankMemorable Member
2 years ago

Yes, you're right.  Thank you.