Azure Databricks connector in Dataflows/Power Query Online

[vgeldbr]

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.

[Anonymous]

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.

[Anonymous]

Do we still not have a dataflow connector for Azure databricks?

[Tonyryan]

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!

[vgeldbr]

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?