Forum Discussion
Power BI Importing Data from Azure Databricks
- 11 months ago
Yes, it’s expected behavior.
In Import mode, Power BI Desktop downloads the data directly from the Databricks storage layer, so the client IP talks to the storage account (hence shows up in firewall logs).That’s why whitelisting the client IP makes Import work.
In DirectQuery, only Databricks queries storage, not the client.
To avoid exposing client IPs, use DirectQuery, VDI, Gateway, or Managed VNET.
Yes, it’s expected behavior.
In Import mode, Power BI Desktop downloads the data directly from the Databricks storage layer, so the client IP talks to the storage account (hence shows up in firewall logs).
That’s why whitelisting the client IP makes Import work.
In DirectQuery, only Databricks queries storage, not the client.
To avoid exposing client IPs, use DirectQuery, VDI, Gateway, or Managed VNET.
Hey Shahid12523 , This is helpful. Do you have any public documentation that can be shared with external users?