Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Getting error Expression.SyntaxError:Token Eof expected

 

Not sure what is wrong with this query. Kindly advise. 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    Agree with what Greg_Deckler said, there's a problem with your M code, something is missing here:

    If you don't know how to modify your M code, you can try enabling the advanced options when connecting to a PostgreSQL database:

    Then, in the SQL statement, put the SQL query you used in the M code into it and connect it.


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks all. As mentioned by Greg and V-   there was "  missing before the select .... so I added that and in the end I also added
      created_at", null, [EnableFolding=true])

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Anonymous Typically that should look like the following:

    ("localhost", "AdventureWorksDW2022", [Query="SELECT * FROM DimCustomer"])
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks all. As mentioned by Greg and V-   there was "  missing before the select .... so I added that and in the end I also added
      created_at", null, [EnableFolding=true])

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks all. As mentioned by Greg and V-   there was "  missing before the select .... so I added that and in the end I also added
    created_at", null, [EnableFolding=true])

    This resolved the error