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
New 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
Contributor III

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 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!