Optimizing connection to a third-party database via Power BI Service: setting up IP address whitelis

[technolog]

There is a database from a third-party service that we need to connect to from Power BI Service. What is the optimal way to set up a white list of ip addresses for this database so that it does not block connection from Power BI Service? Is it possible to use a domain name? What are some ways to do this? Write the pros/cons of these ways? How can I configure using app.powerbi.com domain name as while list: what domain name should be specified on the service side so that there are no connection problems?

 

List of solutions discussed previously on similar topics:

https://community.fabric.microsoft.com/t5/Service/Whitelisting-of-PowerBI-IP-address-range-in-Firewa...

https://community.fabric.microsoft.com/t5/Service/How-to-find-IP-Address-of-PowerBI-Tenant/m-p/21392...

https://community.fabric.microsoft.com/t5/Service/Connecting-to-Azure-SQL-Database-Whitelisting-IPs-...

https://community.fabric.microsoft.com/t5/Desktop/We-want-to-connect-PowerBI-to-the-database-hosted-...

https://community.fabric.microsoft.com/t5/Desktop/Require-IP-range-for-whitelisting-to-access-the-Az...

 

But would like current information for 2023 and specifically your experience with this.

[technolog]

Could you please advise me if you can @GilbertQ @TomMartens @aj1973 @ibarrau 

[aj1973]

@technolog 

As far as I remember the IP addresses for PBI Service are dynamics and chage every week. Can you tell us what type of Database is behind this third party application?

[technolog]

@AJ mySQL

[aj1973]

Have you tried this

https://www.google.com/amp/s/blog.panoply.io/powerbi-mysql-challenges-and-alternatives%3fhs_amp=true

[technolog]

@aj1973 Thanks!

But as I can see here is standart way for connection.

But in order to connect to the database you need to specify an IP-address.

If you use the second method, then firstly it is additional costs, and secondly there will be no possibility to use live connection or direct query directly to mySQL (data in Panoply will not be up to date all the time).