Forum Discussion

Dwivedi15's avatar
Dwivedi15
Icon for Helper I rankHelper I
1 year ago
Solved

Syntax issue while connecting SQL server

After doing a direct query on a database :   -- POPULATE PROJECT REFERENCE AND TOTAL WATER OFFERED -- WITH WaterOffered AS ( SELECT Project_Reference, SUM(Water_Total_AV) AS Total_Water_Offer...
Need Help
  • Fowmy's avatar
    Fowmy
    1 year ago

    Dwivedi15 
    Connect to the SQL server through SSMS or Azure Data Studio and paste this query and ensure it runs without error, it will highlight the lines where you find errors.

  • MattiaFratello's avatar
    MattiaFratello
    1 year ago

    Remove ; at the end of your query

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Dwivedi15 
Thank you for reaching out microsoft fabric community forum.

Not all SQL expressions are supported in power bi, they may load an output while previewing but they wont load into Power BI and will always generate an error
Common table expression is one of those queries which are not supported by power bi.
We have to work around this limitation

 

Thanks and regards