How can I connect postgreSQL with native SQL queries

[tanat_inc]

I plan to select the last item by date and time listed in the table.

Table.Buffer() make my refresh time significantly slower.

1. Will it be better if I do it with SQL ?
2. How could I manually enter SQL query since there is no advance option in PostgreSQL connection option.

M code are below :

let
Source = PostgreSQL.Database("xx.xxx.xxx.xx:port", "db-name"),
sc_aaa_vw_aaa_info = Source{[Schema="sc_aaa",Item="vw_aaa_info"]}[Data],
....
in
...

[amitchandak · Accepted solution]

@tanat_inc , Try if connecting via ODBC can allow you to give query

https://hevodata.com/learn/connect-postgresql-to-power-bi/