Azure Databricks Connectivity with Power BI Cloud - Firewall Whitelisting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-19-2022 12:13 PM
Hi Support Team
We want to connect to tables in Azure Databricks via Power BI. We are able to connect this via Power BI Desktop but when we try to Publish the same, we can see the dataset associated does not refresh and throws error from Powerbi.com
It seems it is down to firewall settings configured at Azure Dababricks side which prevent any Public IPs to access the same. Our network support team has asked us to provide a dedicated IP address or range which will be used by Power BI cloud to connect against Azure Databricks so that they can whitelist the same.
Could you please suggest how we can provide dedicated IPs here or other potential solution here.
I did try to get VNet configured followed by creating a VNet gateway on the Power BI side and IP range for the subnet provided to Azure Databricks teams but it does not seem to solve the issue as we can see the dataset says either gateway or datasource not configured properly when try to map the same.
Could you please suggest the best solution on how we can solve this issue or if there is any particular configuration which you think could have made an impact here?