Connecting PowerBI Cloud to PostgreSQL

Question

How can I connect Power Bi PowergreSql?

Answer 1

In order to connect PostgreSQL to Power BI, you need to configure both of them.

Configuring PostgreSQL

 Edit the pg_hba.conf file :

sudo nano path/to/your/file/pg_hba.conf

 Allow remote connections from host and allow databases. So that you can, edit it according to the own requirements:

pg_hba.conf file must be like:

 edit your postgresql.conf file.

sudo nano path/of/your/file/postgresql.conf ssl = false

 Restart your PostgreSQL to know about the changes.

 Restart by using the command :

sudo service postgresql restart

Configure Power BI

In Power BI Desktop. Select Get data and scroll down the option More.

 Click on PostgreSQL database in the database option and click Connect.

 Enter the server IP and database name.

you need to enter user name and the password and click on Connect.

To know more about this BI tool in detail, you check out our Power BI Certification

   Also, check out our YouTube video to know the fundaments of Power BI and more

Looking for a comprehensive Power BI course? Enroll now!