Reputation: 21
I would like to know if it's possible to use a databricks notebook output as my data source in Power BI. I don't want to export it to csv first.
I tried creating a connection to databricks from Power BI and got a list of all the tables available. However, I would like to use a specific notebook's output as the data source. Is that even possible without having to export it to csv?
Upvotes: 2
Views: 443
Reputation: 1
In Power BI the connectivity to Databricks is only done through the workspace's SQL Endpoint. I don't see any possibility of connecting Power BI to a Databricks notebook.
You can write the notebook output into a Delta Table and use SQL endpoint to read the data into your report.
Upvotes: 0