Forum Discussion
Running SQL in PowerBI
Hello
Is there a way to run SQL statements directly in PowerBI when connecting with a PostgradSQL database ?
Thanks
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.
3 Replies
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/urkhan , I think Value.NativeQuery does the trick.
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.
