Power BI Report Server - SQL Server Data Source Connection

Hello d_gosbell ,

I'm currently trying to connect Power BI Desktop (for Report Server) with SQL Server to connect to a data source.

IT has provided me the Server details, SQL Statement, and Connection String to input here in Power BI.

Once I input the required details here (Server, database, also added a SQL Statement in advanced options).

Next, I input the required database user and password.

The IT dept has connected the ports to ensure connection is established to the SQL Server. However, after that this error comes up. Kindly assist on how to fix this error.

Thanks in advance! Appreciate the support.