Load pgadmin database into Power BI

[nfs03]

I am using power bi web interface/web app. I want to know how can I upload database from pgadmin4 into power bi web interface. I am mac user.

[v-henryk-mstf]

Hi @nfs03 ,

Depending on your confusion, whether you stay connected depends on your connection mode and whether you need to get the latest data from the data source (refreshing the data source).

In case of import mode connection to PostgreSQL, when the connection information is successfully configured, it will not affect your operation unless you click refresh in deskop.
If PostgreSQL is connected in direct query mode, then you need to stay connected to the data source at all times, because you need to send query information to the PostgreSQL data source.

Also, you can check the credential information in data source setting.

For more details, you can read related blog:

PostgreSQL To Power BI: 3 Best Ways To Connect - Learn | Hevo (hevodata.com)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[nfs03]

i didnt understand. I am using import. 

so what do you mean by desktop refresh? 

when i shutdown system and loggin and open power bi the tables are not visible or do i have to open the .pbix file. 

Also, i want that when reload the tables using import , it overwrites the tables instead of creating duplicates/copies

[amitchandak]

@nfs03 , Pg admin, means you are connecting to PostgreSQL?

refer how to connect

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/
https://niftit.com/connecting-power-bi-to-postgresql/

[nfs03]

yes postgres

[nfs03]

from desktop I had simply loaded the db. does that mean it is connected to pgadmin(postgres) or have to make connection still?

[nicocast]

can you fix it? I have the same problem