Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Azure PostgreSQL Direct Query?

Hi!   Can you direct query in PowerBI to an Azure PSQL database? I'm having trouble finding information online. I assumed you could as it is Azure-hosted, but when I try to connect, it fails (using...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous

    Azure SQL database connector in Power BI Desktop can’t be used to connect to Azure PostgreSQL database, however, PostgreSQL database connector should work.

    In your scenario, please install Npgsql 3.1.8 instead of installing latest version of Npgsql driver, and ensure that you install required certificate on the machine that have Power BI Desktop installed. You can follow the guide in this article to install certificate and configure SSL connectivity.

    There is also a similar thread for your reference.
    https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/m-p/135666

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous

Azure SQL database connector in Power BI Desktop can’t be used to connect to Azure PostgreSQL database, however, PostgreSQL database connector should work.

In your scenario, please install Npgsql 3.1.8 instead of installing latest version of Npgsql driver, and ensure that you install required certificate on the machine that have Power BI Desktop installed. You can follow the guide in this article to install certificate and configure SSL connectivity.

There is also a similar thread for your reference.
https://community.powerbi.com/t5/Integrations-with-Files-and/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/m-p/135666

Regards,
Lydia