Forum Discussion
compatibilidad de cifrado - al conectar pbi a POstgres
Hola, me quiero conectar a una base postgres con power bi
Pongo mi credenciales (que me funcionan) y me da este mensaje.
Aclaro que la BD tiene configurado tunnel. Alguien configuro un tunnel en power bi?. O como se hace para conectar PBI a una bd Postgres con tunnel.
Muchas gracias!!
Un Saludo
Ana
Hi AnaVidal,
Thank you for your inquiry submitted through the Microsoft Fabric Community Forum.
Based on my understanding, the error arises because Power BI attempts to establish an encrypted (SSL/TLS) connection to PostgreSQL while the database is being accessed via an SSH tunnel. Power BI does not create or manage SSH tunnels, so SSL negotiation can fail when encryption is already provided by the tunnel. Power BI requires a reachable endpoint (for example, localhost) if the tunnel has been created outside Power BI.
For Power BI Desktop only, you may connect to localhost and set SSL Mode = Disable when an external SSH tunnel is already active. For Power BI Service and scheduled refreshes, the supported approach is to use the On-premises Data Gateway, which securely connects Power BI to PostgreSQL instances located on private networks, VPNs, or behind firewalls. If PostgreSQL supports direct SSL connections, you may alternatively connect without a tunnel by setting SSL Mode = Require.
Additionally please refer to the links below:
Power Query PostgreSQL connector - Power Query | Microsoft Learn
PostgreSQL - Connectors | Microsoft Learn
What is an on-premises data gateway? | Microsoft LearnWe hope this information helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
3 Replies
- v-pnaroju-msft
Community Support
Hi AnaVidal,
Thank you for your inquiry submitted through the Microsoft Fabric Community Forum.
Based on my understanding, the error arises because Power BI attempts to establish an encrypted (SSL/TLS) connection to PostgreSQL while the database is being accessed via an SSH tunnel. Power BI does not create or manage SSH tunnels, so SSL negotiation can fail when encryption is already provided by the tunnel. Power BI requires a reachable endpoint (for example, localhost) if the tunnel has been created outside Power BI.
For Power BI Desktop only, you may connect to localhost and set SSL Mode = Disable when an external SSH tunnel is already active. For Power BI Service and scheduled refreshes, the supported approach is to use the On-premises Data Gateway, which securely connects Power BI to PostgreSQL instances located on private networks, VPNs, or behind firewalls. If PostgreSQL supports direct SSL connections, you may alternatively connect without a tunnel by setting SSL Mode = Require.
Additionally please refer to the links below:
Power Query PostgreSQL connector - Power Query | Microsoft Learn
PostgreSQL - Connectors | Microsoft Learn
What is an on-premises data gateway? | Microsoft LearnWe hope this information helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.
Thank you.
- v-pnaroju-msft
Community Support
Hi AnaVidal,
We would like to follow up and see whether the details we shared have resolved your problem. If you need any more assistance, please feel free to connect with the Microsoft Fabric community.
Thank you. - v-pnaroju-msft
Community Support
Hi AnaVidal,
We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.
Thank you.