Connecting power bI to MS SQL

Question

Hello team,I am trying to connect my power bi to MS SQL data base.1. MS SQL database running in my colleague Laptop and connected to Wifi which same as my laptop also connected.2. I have enabled TC/IP allowing remote connection in my colleague PC3. Authetication to database in Windows&nbsp;But, it was not connecting. Can you support any other things to be checked for successful connection?&nbsp;Error :Data base :&nbsp;Server access setting:&nbsp;&nbsp;

amitchandak · Answer

Karthik12 , Make sure you open 1433 for all type ips 
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver16
&nbsp;
Also, create an inbound and outbound rule in windows firewall to allow connection to 1433 port

Forum Discussion

Connecting power bI to MS SQL

1 Reply

Related content

sql endpoint connection

Fabric SQL Connection End Point

Power BI Gateway SQL Server Connection Issues

SQL Server Connection Error WITH POWER BI

Connecting Power BI to SQL server