We’re excited to announce the Public Preview of the Microsoft Energy BI activity kind in Databricks Workflows, obtainable on Azure, AWS, and GCP.
With this new activity kind, customers can now replace and refresh Energy BI semantic fashions instantly from Databricks. This results in higher complete price of possession, greater effectivity, and ensures knowledge is up-to-date for Energy BI report and dashboard customers.
Key advantages embody:
Direct integration: Publish datasets from Unity Catalog to Energy BI instantly from knowledge pipelines.
Replace Energy BI when your knowledge updates: Considerably cut back refresh prices by updating semantic fashions solely when knowledge modifications.
Knowledge freshness for BI: Ship contemporary 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 instantly from Databricks Workflows. This eliminates the necessity to change contexts between Databricks and Energy BI, streamlining the method of constructing your knowledge obtainable for visualization and evaluation in Energy BI.
Energy BI duties absolutely assist Unity Catalog knowledge objects together with tables, views, materialized views, and streaming tables. The perfect 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 might 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 affords. 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 corresponding to activity dependencies, schedules/triggers, retriesand 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 heart with Energy BI duties. You may 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 acquired 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 it’s worthwhile to do is:
Navigate to your present job
Add a Energy BI activity to the present 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 methodology
Save the duty
Now the following 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 present them a attempt immediately. To get began, please go to Energy BI activity documentation.
Seeking to deepen your Energy BI + Azure Databricks integration?
Take a look at 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 seeking to enhance the Energy BI integration expertise, and would like to hear your suggestions!
