topic Re: Databricks External Table (ADLS) Access with Power BI? in Warehousing & Analytics

Databricks External Table (ADLS) Access with Power BI?

Akshay_Petkar — Tue, 25 Jun 2024 05:09:09 GMT

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

Re: Databricks External Table (ADLS) Access with Power BI?

jacovangelder — Tue, 25 Jun 2024 06:58:04 GMT

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.

Re: Databricks External Table (ADLS) Access with Power BI?

Wojciech_BUK — Tue, 25 Jun 2024 07:22:48 GMT

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