DECLARE statement in PBI using DirectQuery

Hi, I'm using a direct query SQL in PBI. While using a DECLARE statement, it throws an error   Incorrect syntax near the keyqord 'DECLARE'. Incorrect syntax near ')'   My SQL statement is as fol...