Forum Discussion
Helper IVAzure Databricks connector in Dataflows/Power Query Online
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.
4 Replies
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.
vgeldbrThis 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?
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!
