We’re excited to announce the Public Preview of the Microsoft Energy BI activity sort in Databricks Workflows, out there on Azure, AWS, and GCP.
With this new activity sort, customers can now replace and refresh Energy BI semantic fashions straight from Databricks. This results in higher complete value of possession, greater effectivity, and ensures knowledge is up-to-date for Energy BI report and dashboard shoppers.
Key advantages embody:
- Direct integration: Publish datasets from Unity Catalog to Energy BI straight from knowledge pipelines.
- Replace Energy BI when your knowledge updates: Considerably scale back refresh prices by updating semantic fashions solely when knowledge modifications.
- Knowledge freshness for BI: Ship recent insights by robotically pushing modifications to underlying tables and their relationships.
Automate knowledge integration from Unity Catalog with Energy BI
With the Energy BI activity, now you can automate Energy BI semantic mannequin updates and refreshes straight from Databricks Workflows. This eliminates the necessity to change contexts between Databricks and Energy BI, streamlining the method of constructing your knowledge out there for visualization and evaluation in Energy BI.
Energy BI duties totally assist Unity Catalog knowledge objects together with tables, views, materialized views, and streaming tables. The most effective half – you’ll be able to construct Energy BI semantic fashions primarily based on Unity Catalog knowledge objects from a number of schemas and catalogs.
Native integration amongst Unity Catalog, Energy BI, and Microsoft Entra ID means best-in-class safety, governance, and observability. Energy BI semantic fashions may be configured to make the most of OAuth with Single Signal-On to make sure that permissions are honored for every dashboard question together with the complete suite of governance and observability capabilities that Unity Catalog provides. This integration enhances safety and compliance by offering seamless authentication, authorization, and knowledge entry management throughout your Databricks and Energy BI environments.
All the energy of Databricks Workflows and Energy BI
Energy BI duties are constructed into Databricks Workflows so you’ll be able to leverage its superior orchestration and monitoring capabilities. This implies you’ll be able to prolong highly effective options comparable to activity dependencies, schedules/triggers, retries, and notifications to knowledge pipelines that make the most of Energy BI duties.
Energy BI duties assist publishing, updating, and refreshing semantic fashions in Import, Direct Question, and Twin Storage modes, offering you with full flexibility to steadiness efficiency and safety.
Extensibility is entrance and middle with Energy BI duties. You possibly can work with Energy BI duties visually within the Databricks Jobs UI in addition to programmatically by way of the Jobs API and Databricks Asset Bundles.
The way it works
Situation: You may have an present retail analytics knowledge pipeline that ingests knowledge from supply databases utilizing a pipeline activity and applies transformations and aggregations utilizing a pocket book activity, leading to a group of BI-ready tables. You’ve obtained a request to make sure a Energy BI semantic mannequin is in sync with this knowledge because it modifications over time.
Making a Energy BI activity is easy. All you might want to do is:
- Navigate to your present job
- Add a Energy BI activity to the prevailing job and select a SQL warehouse
- Choose a Energy BI connection, workspace, and semantic mannequin
- Choose Import or DirectQuery mode
- Choose Unity Catalog knowledge objects
- Set an authentication technique
- Save the duty
Now the subsequent time your present knowledge pipeline runs, your Energy BI semantic mannequin will robotically replace as your knowledge modifications.
Inside seconds of your job efficiently finishing, your dataset can be up to date in Energy BI, prepared for report creation and evaluation.
Getting Began with Energy BI duties
With Energy BI duties now in Public Preview, you’ll be able to empower knowledge engineers to supercharge their knowledge pipelines and seamlessly combine their business-friendly datasets with Energy BI.
We’re excited to see how you’ll use Energy BI duties and encourage you to offer them a attempt at the moment. To get began, please go to Energy BI activity documentation.
Seeking to deepen your Energy BI + Azure Databricks integration?
Try Half 1 and Half 2 of our connectivity sequence:
Collectively, these blogs present important greatest practices to optimize safety and efficiency when connecting Energy BI to Azure Databricks.
The Databricks workforce is at all times trying to enhance the Energy BI integration expertise, and would like to hear your suggestions!
