abort query execution within the query

[BIXL]

Hey All,

Is there a way to cancel/abort query execution within the query ?

for example inside the query I want to write something like this :

if param1>param 2 then abort (abort the query and stop all data refresh)

thanks

[v-ljerr-msft · Accepted solution]

Hi @BIXL,

If I understand you correctly, the follow query(M) should work in your scenario. 

AbortCheck = if param1>param 2 then error "Abort" else PreviousStep

Regards