cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Databricks External Table (ADLS) Access with Power BI?

Akshay_Petkar
Contributor

Can we to connect Power BI directly to an Azure Databricks external table located in ADLS using cluster credentials?

2 REPLIES 2

jacovangelder
Honored Contributor

Yes, that's no problem at all. If you've registered the table in the hive metastore or in the (unity) catalog then PowerBI will be able to connect to it. 

Wojciech_BUK
Valued Contributor III

It depends
- if you want to connect Power BI to table (wither external or managed) you can do it  BUT it will be through cluster (each time you run something on Power BI desktop - it will wake up cluster or SQL endpoint and you will access data in this way)

- in case you want to access table directly on Storage Level you might be looking for Shortcut capability in MS Fabric but then you do not have control over permissions on such a table 

 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group