Forum Discussion
technolog
Super User
Super UserOptimizing 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 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-Firewall/m-p/1072193
https://community.fabric.microsoft.com/t5/Service/How-to-find-IP-Address-of-PowerBI-Tenant/m-p/2139213#M142252
https://community.fabric.microsoft.com/t5/Service/Connecting-to-Azure-SQL-Database-Whitelisting-IPs-for-Desktop/m-p/2430505
https://community.fabric.microsoft.com/t5/Desktop/We-want-to-connect-PowerBI-to-the-database-hosted-on-an-external/td-p/1650883
https://community.fabric.microsoft.com/t5/Desktop/Require-IP-range-for-whitelisting-to-access-the-Azure-SQL-server/td-p/1965915
But would like current information for 2023 and specifically your experience with this.
5 Replies
- technolog
Could you please advise me if you can GilbertQ TomMartens aj1973 ibarrau
