https://community.fabric.microsoft.com/t5/Developer/Database-conenctivity/m-p/2131229#M32348 <P>Hi&nbsp;@Anonymous</a>&nbsp;</P> <P>I think you can try to connect to your&nbsp;<SPAN>remote SQL Server by IP address with your Power BI Desktop.&nbsp;Here is using (IP,Port) for the Server field in Power BI Desktop.</SPAN></P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 699px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/611595iBA2895F4F8C78D47/image-size/large?v=v2&amp;px=999" role="button" title="1.png" alt="1.png" /></span></SPAN></P> <P><SPAN><A href="https://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/" target="_self" rel="nofollow noopener noreferrer">Here</A>&nbsp;a good article about how to identify SQL Server TCP IP port being used for your reference.</SPAN></P> <P>&nbsp;</P> <P>Best Regards,<BR />Rico Zhou</P> <P>&nbsp;</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 13 Oct 2021 05:41:53 GMT Anonymous 2021-10-13T05:41:53Z https://community.fabric.microsoft.com/t5/Developer/Database-conenctivity/m-p/2126207#M32314 <P>How can i conenct my local computer to the virtual SQL server on premises.<BR /><BR /></P><P>i tried Get Data option(SQL database) , but the authentication is failed evertime i try (both Windows &amp; SQL auth) failed.<BR /><BR />How can i connect directly to SSMS from my pc thorugh PowerBi, without installing SSMS in my local PC?</P> Mon, 11 Oct 2021 05:55:30 GMT https://community.fabric.microsoft.com/t5/Developer/Database-conenctivity/m-p/2126207#M32314 Anonymous 2021-10-11T05:55:30Z https://community.fabric.microsoft.com/t5/Developer/Database-conenctivity/m-p/2131229#M32348 <P>Hi&nbsp;@Anonymous</a>&nbsp;</P> <P>I think you can try to connect to your&nbsp;<SPAN>remote SQL Server by IP address with your Power BI Desktop.&nbsp;Here is using (IP,Port) for the Server field in Power BI Desktop.</SPAN></P> <P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 699px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/611595iBA2895F4F8C78D47/image-size/large?v=v2&amp;px=999" role="button" title="1.png" alt="1.png" /></span></SPAN></P> <P><SPAN><A href="https://www.mssqltips.com/sqlservertip/2495/identify-sql-server-tcp-ip-port-being-used/" target="_self" rel="nofollow noopener noreferrer">Here</A>&nbsp;a good article about how to identify SQL Server TCP IP port being used for your reference.</SPAN></P> <P>&nbsp;</P> <P>Best Regards,<BR />Rico Zhou</P> <P>&nbsp;</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 13 Oct 2021 05:41:53 GMT https://community.fabric.microsoft.com/t5/Developer/Database-conenctivity/m-p/2131229#M32348 Anonymous 2021-10-13T05:41:53Z