Forum Discussion
error: 40 - Could not open a connection to SQL Server
Hi all. have an issue with connection to SQL server. and this just start happens recently. before it works perfect. I can connect to server succesfully via MSSMS but not via Power BI, it the ...
Hi kvitnitskiy ,
1. Please check if the outbound traffic over port 1433 port is allowed on the machine which has desktop runs.
2. Please add firewall rules to specify which IP address ranges from the Internet are allowed. See: Azure SQL Database server-level and database-level firewall rules.
3. Go to File Menu > Options and Settings > Data Source Setting then clear the permission for datasource. Then use servername,port as server in Power BI Desktop to connect to SQL database
You can also refer to these threads:
https://community.powerbi.com/t5/Power-Query/Failed-to-connect-to-SQL-Server/td-p/28939
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.