Forum Discussion

jsBrizius's avatar
jsBrizius
Helper I
10 years ago
Solved

Why is DECLARE not supported (Error)?

    It seems for some reason a DECLARE in the SQL Statement does not work?   Here is a simple example...    
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    Hi jsBrizius,

     

    We reproduced same issue as yours. Power BI Desktop will always resolve the front end input SQL statement as a derived table. So when passing the SQL statement, the "Decalare"statement cause syntax error. See the fetched query in SQL profiler:

     

     

     

    We have reported this issue internally.

     

    Regards,

jsBrizius's avatar
jsBrizius
Helper I
10 years ago

I am getting an error when I try to Close & Apply the Query Editor.  My query seems to work fine until I try to Close and Apply.

 

jsBrizius's avatar
jsBrizius
Helper I
10 years ago

 

 

 

 

 

So apparently you cannot use DECLARE?  I still get the same error with the following query.