Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-17-2024 02:10 PM
-
Publish Databricks Tables to a Power BI Dataset:
- Sign in to your Databricks workspace and click on
Catalogin the sidebar to open Catalog Explorer. - Select a compute resource from the drop-down list at the top right.
- Open a catalog and select the schema or tables to be published. Avoid selecting from a hive metastore or the samples catalog.
- On the upper right, click
Use with BI toolsfor a schema orOpen in a dashboardfor a table. - Select
Publish to Power BI workspace. - In the Connect to partner dialog, click
Connect to Microsoft Entra IDto authenticate. - In the Power BI workspaces, select the Power BI workspace.
- In Dataset Mode, select either
DirectQueryorImport. - In Authentication Method in Power BI, select
OAuthorPAT (Personal Access Token). Databricks recommends using OAuth for fine-grained access control and user-level auditing. - In Dataset Name, select
Publish as a new data setorUse an existing data set.
- Sign in to your Databricks workspace and click on
-
Post-Publishing:
- Once the dataset is published, it will be available in Power BI Online within 10 to 20 seconds, ready for report creation and analysis.