We’re excited to announce the Common Availability of Publish to Microsoft Energy BI Service from Unity Catalog, an integration that makes it simple to create Energy BI net experiences out of your Unity Catalog knowledge in just some clicks. This function allows seamless catalog integration and knowledge mannequin sync, permitting you to publish datasets on to Energy BI Service with out leaving the Databricks UI.
Unity Catalog supplies a single supply of fact to your group’s knowledge and AI belongings, offering open connectivity to any knowledge supply, unified governance with detailed lineage monitoring, complete monitoring, and assist for open sharing and collaboration. This seamless integration with Energy BI environments delivers actionable knowledge intelligence throughout your group, fostering a data-driven tradition and enabling extra knowledgeable decision-making.
Seamless Integration with Unity Catalog and Energy BI Service
With Publish to Energy BI, now you can combine Energy BI dataset creation instantly into your Databricks workflows and knowledge pipelines. This eliminates the necessity to swap contexts between Databricks and Energy BI Desktop, considerably simplifying the method of constructing your knowledge obtainable for visualization and evaluation.
Publish to Energy BI would not simply switch particular person tables – it synchronizes whole schemas, together with desk relationships. This implies your fastidiously crafted knowledge mannequin in Unity Catalog, full with major and international key relationships, is preserved when printed to Energy BI. This protects important time and ensures consistency between your knowledge lake and BI layer.
Native integration with Energy BI and Microsoft Entra ID, supplies best-in-class governance and observability. Energy BI semantic fashions may be configured to make the most of OAuth with Single Signal-On, permitting particular person consumer identities to move into Unity Catalog and making certain that permissions are honored for every dashboard question and audited finish to finish. This integration ensures seamless authentication, authorization, and knowledge entry management throughout your Databricks and Energy BI environments, enhancing safety and compliance
Key advantages embody:
- Direct integration: Publish datasets to Energy BI proper from inside Databricks, on the finish of your knowledge pipelines.
- No handbook connection administration: Routinely deal with connections and credentials, eradicating the necessity for handbook setup.
- At all times up-to-date: Simply push modifications to underlying tables and their relationships mechanically.
- Single supply of fact: Outline entity relationships as soon as in Unity Catalog, and have them mirrored in Energy BI with out duplication of effort.
Streamlined Publishing Course of: How It Works
Publishing a dataset to Energy BI is now so simple as a couple of clicks:
- Navigate to your required schema or desk in Unity Catalog
- Click on “Use with BI instruments” or “Open in a dashboard”
- Choose “Publish to Energy BI workspace”
- Login to Energy BI, select your workspace and dataset choices
- Click on “Publish to Energy BI”
Inside seconds, your dataset will probably be obtainable in Energy BI On-line, prepared for report creation and evaluation.
Wanting Forward: Upcoming Roadmap
We goal to enhance the Publish to Energy BI expertise. Upcoming options embody API-based publishing for dataset administration and scheduling and enhanced admin capabilities for managing user-published datasets throughout workspaces.
Get Began
Publish to Energy BI from Unity Catalog is now obtainable to all Databricks clients. To get began, guarantee you might have the mandatory permissions in each Databricks and Energy BI, then navigate to your Unity Catalog knowledge and search for the “Publish to Energy BI” possibility.
For detailed directions and greatest practices, try our documentation (AWS, Azure, GCP)
We’re excited to see how this integration will speed up your knowledge analytics workflows and sit up for your suggestions as we proceed to reinforce this function.