Power bi sql connection

[metecakmak]

Hello,

I'm new on Power bi. I have a code on SQL server and I want to connect Power bi to visualize my codes but my SQL server on a virtual machine (VMware). When I clicked get-data on power bi it requires server name then says server name not found. My server name is correct checked many times. Also, I realized my server name is fully uppercase but after entering the server name power bi shows the server name fully lowercase. 

Do you think it might be a reason? 

[Anonymous]

Hi @metecakmak ,

This is an article describes how to connect to your SQL on Azure virtual machine (VM).

More details: Connect to a SQL Server virtual machine on Azure

• The way a client connects to a SQL Server VM differs depending on the location of the client and the networking configuration.

If you provision a SQL Server VM in the Azure portal, you have the option of specifying the type of SQL connectivity.

• If you want to connect to your SQL Server database engine from the internet, select Public for the SQL connectivity type in the portal during provisioning. 
• When you choose Private for the SQL connectivity type in the portal, Azure configures most of the settings identical to Public. The one difference is that there is no network security group rule to allow outside traffic on the SQL Server port (default 1433).

I have found a similar post, please refer to the following topic to see if it helps you.

https://community.powerbi.com/t5/Report-Server/Can-not-connect-to-SQL-from-VM/m-p/1453886

• You need to allow remote connections for your SQL in VM. follow steps from the article to solve the problem.

https://medium.com/@nishancw/how-to-enable-remote-connections-to-sql-server-dc5b6c812b5

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[metecakmak]

Hello, 

Thank you for the detailed answer but still I'm not able to connect sql server to power bi. I just keep getting the server name was not found even though I tried every steps in the article.

[parry2k]

@metecakmak can you connect to SQL server thru any other tools like SSMS from your machine? If yes, use the same credentials, connection in Power BI.

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.