Data source connection on Power BI Report Server failed

For the SQL issue you might need to talk to someone in your IT network team. It sounds like there could be a firewall issue or something like that preventing your Report Server from "seeing" the SQL Server.

For the Postgres issue it sounds like you do not have the Postgres drivers installed on the Report Server. Someone will need to install those in order for you to access data from Postgres.

Hi KC_Wong ，

This error usually means that the client can't find the SQL Server instance. This normally happens when at least one of the following problems exist:

• The name of the computer hosting the SQL Server
• Instance does not resolve the the correct IP
• The TCP port number is not specified correctly

Checklist:

1. SQL Server are up are runing
2. check the correct instance name
3. add in exception in firewall
4. check if anti virus is using it
5. check the sql browser services

Please refer the following Microsoft document and cases that could also help you:

1. https://community.powerbi.com/t5/Desktop/SQL-Connection-error-Named-Pipes/td-p/29203
2. https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-the-sql-server-database-engine?view=sql-server-ver15
3. https://support.microsoft.com/en-us/help/4009936/solving-connectivity-errors-to-sql-server

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien