Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
bsz412
Helper III
Helper III

Connecting to Azure Databricks

Hi experts, 

 

I am not too experienced with Power BI yet, and I am wondering what is the best way to set up connection between Azure Databricks and Power BI.

Shall I establish the connection in desktop, by choosing Azure Databricks when clicking add data? I guess import would be my best choice as daily datarefresh would be sufficient. What I am confused about is what happens if I import the data this way to desktop, I create the data model and the report, then I publish it to service. Do I schedule the daily refresh in service on the uploaded datamodel?

Or is it better to connect to databricks in PBI service, create a dataflow and import that dataflow to desktop? 

 

Also, I see there is a new connection method available now, by using Partner Connect. Any experience with that? 

 

thanks for your help!

 

 

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @bsz412 

 

In the past, data was connected through Spark Connector, but now you can connect data directly through Azure Databricks Connector. When you publish to service, you only need to enter credentials to refresh data. 

vjaneygmsft_1-1644463907748.png

 

vjaneygmsft_2-1644463998900.png

Reference:

Connecting Power BI to Azure Databricks | Gerhard Brueckl on BI & Data (gbrueckl.at)

 

 With Partner Connect, you can also connect to Databricks.

Check this: 

Announcing Power BI integration with Databricks Partner Connect | Microsoft Power BI Blog | Microsof...

Connect with Power BI Desktop by using Partner Connect

 

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

View solution in original post

3 REPLIES 3
JavierC
Regular Visitor

Hi all,

 

I'm using PowerBI version 2.112.1161.0 32-bit (dicember 2022) and I don't have Databricks connector on the list. As far I read, this connector is in-built since version september 2020.

 

Does anyone have a clue about this issue?

 

v-janeyg-msft
Community Support
Community Support

Hi, @bsz412 

 

In the past, data was connected through Spark Connector, but now you can connect data directly through Azure Databricks Connector. When you publish to service, you only need to enter credentials to refresh data. 

vjaneygmsft_1-1644463907748.png

 

vjaneygmsft_2-1644463998900.png

Reference:

Connecting Power BI to Azure Databricks | Gerhard Brueckl on BI & Data (gbrueckl.at)

 

 With Partner Connect, you can also connect to Databricks.

Check this: 

Announcing Power BI integration with Databricks Partner Connect | Microsoft Power BI Blog | Microsof...

Connect with Power BI Desktop by using Partner Connect

 

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey

Hello

​What is the best practice here -

1. To develop the reports by connecting to Databricks using individual PATs.

2. Then, after deploying the report to PowerBI service, change the data source credentials to point to the PAT of the Service Principal so data import is done based on defined schedule.

3. PowerBI report users then need not be having Databricks accounts as the underlying service principal is fetching data for them.

Is my understanding correct?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors