Forum Discussion
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...
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.
Hmm, can't find the exact page (will have to ask our specialist tomorrow). But it is similar to this
Fast copy in Dataflow Gen2 - Microsoft Fabric | Microsoft Learn
Thank you!