Forum Discussion
Cannot connect Power BI with SQL server
Hi, Anonymous
For more information about gateway configuration, you can check out my article below:
Solved: Connection Error with On-Premises Data Gateway - Microsoft Fabric Community
Next, I'll show you how to establish a gateway connection to SQL Server in Power BI service:
Next, configure this gateway connection for your semantic model:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I went through your steps, thanks so much for such a detail instruction. I set up connection in Power BI online, but unfortunately this does not resolve the problem, that I am unable to connect with this data base in Power BI Desktop in the first place, so I can create my dashboard from scratch. In my other response in this trail, I shared error message I got.
Hi, Anonymous
In a computer we can have many port numbers.
When we want to access certain services, we need to have the database server IP/name, port number to access the contents. When we only have a port number, Power BI and other applications don't know which computer to go to access the database that corresponds to the port number you provide.
For example, I have VM1, VM2, VM3, VM4. When we enter the port number directly in VM4 to access the database, this causes the computer to not know which machine to access the database. Typically, the server name/IP is used to identify a computer.If you only have a port number, you need to communicate with your IT to get the IP/name of the SQL Server server.
Best Regards
Jianpeng Li
I will reach out to data base owner and ask for additional information. I will accept your solutions if I get luck with connection. Thanks for your support!