Forum Discussion
technolog
Super User
2 years agoOptimizing connection to a third-party database via Power BI Service: setting up IP address whitelis
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 n...
aj1973
Community Champion
2 years agoHave you tried this
https://www.google.com/amp/s/blog.panoply.io/powerbi-mysql-challenges-and-alternatives%3fhs_amp=true
- technolog2 years ago
Super User
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).