Forum Discussion

Revathi_Kannan's avatar
Revathi_Kannan
Helper I
4 years ago

Unable to Connect Power BI with SQL Query

I am trying to connect Power BI with SQL query with Direct import query wherein it works fine in SQL and power editor but after proceeding with "Load" the below error occurs. I am looking for the solution for past 2 weeks. Can anyone assist me.

 

Error : 
Microsoft SQL: Incorrect syntax near the keyword 'with'. Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. Incorrect syntax near ')'.

1 Reply

  • themistoklis's avatar
    themistoklis
    Community Champion
    4 years ago

    Hello Revathi_Kannan ,

     

    This is a MS SQL Server error message.

     

    Start the WITh SQL statement (Common Table Expression) by adding a semicolon before it:

    like below:

    ;WITH