Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Cannot connect Power BI with SQL server

Hi, I found issues with connecting Micsrosft SQL Server with Power BI. I do not have any experience in such connections, so I am blindly doing different steps but I simply don't uderstand what I am d...
help needed
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, I mentioend that I got no luck with this connection. I tried houndrets times to go through it (as this is very similar to any other Power BI getting data step, which I do on a daily basis). The problem is with connection:

 

1. Open Power BI => Get Data => SQL Server 

 

but different errors appears. E.g. I have port number instead of server name (but I read this is the same and it does not matter), so when I put numers only, this is what I get:

 

 

 

So i tired putting like "port:12345", this brings me to the next step, of adding cretindials.

 

I have been given user and password so I put them:

 

 

 

again this is what I got:

 

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi, Anonymous 

I think you have to have the sql server name and port number. Here I take the sql server of my VM1 (port 1433) machine as an example.

Here is the SQL Server server name to look for vm1:

Now I'm connecting to VM1's sql server in my other machine:

Format:

servername,portNumber

If you can connect to this sql server in SSMS, there is no problem. Next, let's connect it in Power BI desktop:

 

 

Power BI desktop accesses our database as normal. In summary, you need to have the SQL Server server name and the corresponding port number, which is required.

 

 

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.