Forum Discussion

jsBrizius's avatar
jsBrizius
Icon for Helper I rankHelper 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,

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
Icon for Advocate I rankAdvocate 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