Recently I got a requirement to connect to a Microsoft SQL Server Database that runs on a custom port. The default port is 1433 and we do not need to specify this port in SQL Server Management Studio (SSMS) and in Power BI. When I checked in the options, I couldn’t find an option to specify the port.
The trick is simple, we can specify the port by putting a comma after the database host.
A sample screenshot of the same is given below. In the below screenshot, the server IP address is 192.168.10.1 and the port is 42199. In the Server Name field, we just need to enter host and port separated by comma.
I hope this tip is useful. Feel free to comment incase of any questions. !!