Forum Discussion

claudedjale's avatar
claudedjale
Microsoft Employee
11 months ago
Solved

Power BI Importing Data from Azure Databricks

Hi experts,    I have a question. I am working with a customer right now who set up a power BI desktop app in their environment to query data from Azure Databricks. It looks like the configurations...
Need Help
  • Shahid12523's avatar
    Shahid12523
    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.

lbendlin's avatar
lbendlin
Super User
11 months ago
It is normal that the client IP is in direct communication with the storage endpoint when the "import" method is selected?

 

What is normal these days... Anyways, yes - this direct connection has been touted as a new hot feature in Databricks, aimed at reducing the network impact of these transfers.  Very much similar to the DMA (Direct Memory Access)  feature of the microprocessors of yore.