Walter_C
Databricks Employee
Databricks Employee

 

  • Publish Databricks Tables to a Power BI Dataset:

    • Sign in to your Databricks workspace and click on Catalog in 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 tools for a schema or Open in a dashboard for a table.
    • Select Publish to Power BI workspace.
    • In the Connect to partner dialog, click Connect to Microsoft Entra ID to authenticate.
    • In the Power BI workspaces, select the Power BI workspace.
    • In Dataset Mode, select either DirectQuery or Import.
    • In Authentication Method in Power BI, select OAuth or PAT (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 set or Use an existing data set.
  • 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.