Forum Discussion
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 sol...
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