https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-Report-Server-SQL-Server-Data-Source-Connection/m-p/2563839#M24499 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="109790" data-lia-user-login="d_gosbell" class="lia-mention lia-mention-user">d_gosbell</a>&nbsp;,</P><P>&nbsp;</P><P>I'm currently trying to connect Power BI Desktop (for Report Server) with SQL Server to connect to a data source.</P><P>IT has provided me the Server details, SQL Statement, and Connection String to input here in Power BI.</P><P>&nbsp;</P><P>Once I input the required details here (Server, database, also added a SQL Statement in advanced options).</P><P>Next, I input the required database user and password.</P><P><img /></P><P>&nbsp;</P><P>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.</P><P><img /></P><P>&nbsp;</P><P>Thanks in advance! Appreciate the support.</P> Tue, 07 Jun 2022 12:21:22 GMT niyati_61 2022-06-07T12:21:22Z https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-Report-Server-SQL-Server-Data-Source-Connection/m-p/2563839#M24499 <P>Hello&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="109790" data-lia-user-login="d_gosbell" class="lia-mention lia-mention-user">d_gosbell</a>&nbsp;,</P><P>&nbsp;</P><P>I'm currently trying to connect Power BI Desktop (for Report Server) with SQL Server to connect to a data source.</P><P>IT has provided me the Server details, SQL Statement, and Connection String to input here in Power BI.</P><P>&nbsp;</P><P>Once I input the required details here (Server, database, also added a SQL Statement in advanced options).</P><P>Next, I input the required database user and password.</P><P><img /></P><P>&nbsp;</P><P>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.</P><P><img /></P><P>&nbsp;</P><P>Thanks in advance! Appreciate the support.</P> Tue, 07 Jun 2022 12:21:22 GMT https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-Report-Server-SQL-Server-Data-Source-Connection/m-p/2563839#M24499 niyati_61 2022-06-07T12:21:22Z https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-Report-Server-SQL-Server-Data-Source-Connection/m-p/2566521#M24511 <P>Hi,</P><P>Are you able to connect through SQL Server Management Studio (SSMS) with the same information? Added the reference link for your scenario to check -&nbsp;<A href="https://stackoverflow.com/questions/3270199/a-connection-was-successfully-established-with-the-server-but-then-an-error-occ" target="_blank">https://stackoverflow.com/questions/3270199/a-connection-was-successfully-established-with-the-server-but-then-an-error-occ</A></P><P>&nbsp;</P><P>Thanks</P><P>Hari</P> Wed, 08 Jun 2022 12:10:29 GMT https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-Report-Server-SQL-Server-Data-Source-Connection/m-p/2566521#M24511 Hariharan_R 2022-06-08T12:10:29Z