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,

vissvess's avatar
vissvess
Icon for Helper V rankHelper V
6 years ago

But what is this in case of Direct query..!
This converting the query into function and then invoking to a query and loading is converting the query to import mode..

What should I do for Direct query.

HarshVidap's avatar
HarshVidap
Frequent Visitor
4 years ago

I have the same issue, were you able to find the solution?