Getting error Expression.SyntaxError:Token Eof expected

[sush08gi]

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

[sush08gi]

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

[Anonymous]

Hi @sush08gi ,

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.

[sush08gi]

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]

@sush08gi Typically that should look like the following:

("localhost", "AdventureWorksDW2022", [Query="SELECT * FROM DimCustomer"])

[sush08gi]

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])