Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have set up a query in Power BI desktop using the Azure Databricks connector. I'm trying to move this to a dataflow and am surprised to find that the Azure Databricks connector does not appear to be available or be supported in Power Query Online (Dataflows). Is this correct? I did find a workaround using the Spark connector but also saw comments about poor performance doing it that way.
Hi @vgeldbr ,
Maybe you can take a try to connet to Azure Databricks via ODBC connector.
https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html
https://medium.com/@mauridb/powerbi-and-azure-databricks-193e3dc567a
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Do we still not have a dataflow connector for Azure databricks?
That medium link was extremely helpful (wound up following it to https://mauridb.medium.com/powerbi-and-azure-databricks-2-d0ed16427d36). I've been on and off trying to figure this out all week. Thank you so much!
This would require a gateway which is unnecessary and slow down query processing. I did find a workaround using the Spark connector as I mentioned but it is slow. Why would Microsoft make available the Azure Databricks connector in Desktop but not in Dataflows given the latter surely is a primary potential usecase for using it?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.