We want to connect PowerBI to mysql database hosted on an external server

Question

The database is available externally via hostname, username and password but limited to IP. Currently, Power BI cannot see our database as I have not whitelisted the PowerBI IP address on the external database. How do I find out the Power BI IP address, so that we can whitelist this on the external database and allow PowerBI to view the data? Remote connections have been enabled?

question from:https://stackoverflow.com/questions/66065354/we-want-to-connect-powerbi-to-mysql-database-hosted-on-an-external-server

Answer 1

PowerBI is Azure cloud-based service and its IP address changes with time within each region. You can download the Azure IP Ranges and Service Tags – Public Cloud to configure your firewall rules.

Also refer:

1. Community forum link
2. Documentation link
3. Service gateway