michaeljc70Advocate II10 years agoQuery with CTE gives error I used SQL Server and a query that uses a CTE. It gives me an error "Incorrent syntax near the Keyword 'WITH'. ......."if this is a common table expression......previous statement must be terminated...Show More
NobbyFrequent Visitor9 years agoIt's a shame. I also have this problem. I've removed the CTE but the code is much less readable/maintainable. Ho hum.
jimjaoNew Member to Nobby8 years agoHi all, Using Power BI Desktop (October 2017), I was able to use CTE query along with an OLE DB connection to the SQL Server.This is no longer truth. Jim Jao
Related contentQuery Errorskusto error- partial query failureGroup by gives error - Power QueryUse API to execute query to dataset giving Unauthorized ErrorQuery Resources Exceeded Error
