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 III

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 

 

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now