Issue connecting powerBI to dedicated server for remote SQL (import data to PowerBI)

[Alexj1]

Hey, 
   I am trying to connect my dedicated remote SQL server with Power BI. But I am unable to find the hostname or Ip address of Power BI to whitelist in my server. It connects the server if I allow all the IPs to connect to the server But it is not recommended. I need an IP address or hostname to connect. I searched a lot, but I couldn't find any answer.  Kindly guide me

[Anonymous]

Hi  @Alexj1 

If you want to connect to SQL server , you need to enter the data source credentials in Power BI Desktop . SQL's certificate usually includes the host name or Ip address . So what you need to make sure is that the computer where PBI Desktop is located has remote access to your data source . Maybe you can refer to the following link .

How to connect to a remote SQL Server (sqlshack.com)

Best Regards,
Community Support Team _ Ailsa Tao

[Alexj1]

Thanks, Ailsa Tao for the response. But the issue is to access remote MySql I need to provide access to the Power BI desktop by adding its IP or hostname in my cpanel remote SQL. I am able to access the database using '%" in remote mySQL but as you know it's not safe. Can you please guide me on where can I find the IP address or hostname which can be added to the whitelist?

[Anonymous]

Hi @Alexj1 

You can download the Microsoft Azure Datacenter IP list, which is updated weekly or configureto allow outbound connections to FQDN's rather than IP's.

You can refer to these thread:https://community.powerbi.com/t5/Service/Mass-IP-Whitelisting-for-Azure-Datacenter/m-p/173665 

https://stackoverflow.com/questions/54456612/how-to-allow-the-azure-data-center-ip-address-dynamical... 

Hope it will help you !

Best Regards,
Community Support Team _ Ailsa Tao

[Alexj1]

Hi Ailsa Tao,

                Thanks for the support.  You have shared the list from 24 August 2020, Is there any other updated list for this year 2023? 

[Alexj1]

Hi Alisa Tao,

I have found the solution and am able to connect PowerBI to my server. Thanks for the support.

[cxammar]

Hello @Alexj1 , sorry to bother. I'm trying to achieve the same as you did without opening all inbound network traffic to my Mysql database. How did you manage to whitelist powerBI IPs ? 

[Alexj1]

Hi @cxammar ,

        No worries. You need to white list your Public IP address in your server. If you are using Cpanel then you need to whitelist your IP address in remote MySQL. then you will be able to get data in the Power BI desktop.