Load pgadmin database into Power BI

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/

 

 

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.