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
4 years ago

Hi Team

While connecting with azure postgre sql database to power bi desktop asking for server name and database name  may i know where to take credentials from azure portal and How can i get password 

and from which mode we need to take(import or direct query) need some documents or tutorial 

after providing credentials we authentication wrong need some information for where we can get all those details pls provide screen shots