Databricks External Table (ADLS) Access with Power BI?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2024 10:09 PM
Can we to connect Power BI directly to an Azure Databricks external table located in ADLS using cluster credentials?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-24-2024 11:58 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-25-2024 12:22 AM
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