Running SQL in PowerBI

[urkhan]

Hello

Is there a way to run SQL statements directly in PowerBI when connecting with a PostgradSQL database ? 

Thanks

[v-robertq-msft · Accepted solution]

Hi, @urkhan 

According to my test, you can enter the SQL statement here to execute the specific query when connecting to the PostgreSQL database. But you have to enter the correct database name.

More info about working with SQL database in Power BI Desktop

Best Regards,

Community Support Team _Robert Qin

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

[CNENFRNL]

@urkhan , I think Value.NativeQuery does the trick.

[amitchandak]

@urkhan , Direct query is an option with Postgresql. But that does not mean you can write SQL. Power bi will send the SQL. You have to write in DAX only.

Connect to PostgresSQL - Do miss any step in solution of topic 1
https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/