Unable to Connect Power BI with SQL Query

[Revathi_Kannan]

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 ')'.

[themistoklis]

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