Forum Discussion

balajiratnala6's avatar
balajiratnala6
Helper I
3 years ago
Solved

DirectQuery with SQL statement from Power BI advanced option in Power BI Desktop throwing error

DirectQuery with SQL statement from Power BI advanced option throwing error DirectQuery as below

 

 

Need Help
Show and Tell
  • balajiratnala6's avatar
    balajiratnala6
    3 years ago

    amitchandak  Thanks for reply.  Issue resolved. semicolon at end of query caused that issue. Removing semicolon from query resolved issue.

     

    Thanks,

    balaji R

2 Replies

  • balajiratnala6's avatar
    balajiratnala6
    Helper I
    3 years ago

    amitchandak  Thanks for reply.  Issue resolved. semicolon at end of query caused that issue. Removing semicolon from query resolved issue.

     

    Thanks,

    balaji R

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    balajiratnala6 . Either the credential or path is wrong or it is a very old version of the SQL server not supported for direct query

     

    Make sure you are able to connect to SSMS on the same machine.

     

    Also, share the version of the SQL server used