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

Is this a bug?

 

My query is much harder to read without the ability to declare a variable.  Seems strange that it works fine in the Query Editor.

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
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,

  • HarshVidap's avatar
    HarshVidap
    Frequent Visitor
    4 years ago

    Was the issue resolved?


    Update: The issue wasn't resolved and you still can't use temp tables or declare statements.

    • WTsrnl's avatar
      WTsrnl
      Advocate I
      3 years ago

      Maybe we can make this into a new Topic, since this is probably not at the top of their list, or even close to the first 5 pages of features.

       

      That way, we can trigger a new response

  • schuffa's avatar
    schuffa
    Advocate III
    2 years ago

    Any news on an ETA when this will work??