As mentioned earlier the new connector now also supports Azure Active Directory authentication which allows you to use the same user that you use to connect to the Databricks Web UI! The last part is then the authentication. (NOTE: you can simply copy the Server Hostname and the HTTP Path from the cluster page) As this connection is always bound to an existing cluster you need to go the clusters details page and check the Advanced Tab “JDBC/ODBC” as described here: You find all the necessary information via the Databricks Web UI. The next dialog that pops up will ask you for the hostname and HTTP path – this is very similar to the Spark connector. With the new connector you can simply click on “Get Data” and then either search for “Azure Databricks” or go the “Azure” and scroll down until you see the new connector: So, I am very happy that there is finally an official connector in PowerBI to access data from Azure Databricks! Previously you had to use the generic Spark connector ( docs) which was rather difficult to configure and did only support authentication using a Databricks Personal Access Token. For those scenarios, you still need to use a proper reporting tool, which usually is Power BI when you are already using Azure and other Microsoft tools. Even though notebooks offer some great ways to visualize data for analysts and power users, it is usually not the kind of report the top-management would expect. I work a lot with Azure Databricks and a topic that always comes up is reporting on top of the data that is processed with Databricks.
0 kommentar(er)
