We’re excited to announce the Public Preview of the Microsoft Energy BI job kind in Databricks Workflows, out there on Azure, AWS, and GCP.
With this new job kind, customers can now replace and refresh Energy BI semantic fashions instantly from Databricks. This results in higher whole price of possession, increased 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 instantly 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 routinely pushing modifications to underlying tables and their relationships.
Automate knowledge integration from Unity Catalog with Energy BI
With the Energy BI job, now you can automate Energy BI semantic mannequin updates and refreshes instantly from Databricks Workflows. This eliminates the necessity to swap contexts between Databricks and Energy BI, streamlining the method of creating your knowledge out there for visualization and evaluation in Energy BI.
Energy BI duties absolutely help Unity Catalog knowledge objects together with tables, views, materialized views, and streaming tables. The most effective half – you possibly can 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 could 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 total suite of governance and observability capabilities that Unity Catalog presents. 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 possibly can leverage its superior orchestration and monitoring capabilities. This implies you possibly can prolong highly effective options reminiscent of job dependencies, schedules/triggers, retries, and notifications to knowledge pipelines that make the most of Energy BI duties.
Energy BI duties help 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 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’ve an current retail analytics knowledge pipeline that ingests knowledge from supply databases utilizing a pipeline job and applies transformations and aggregations utilizing a pocket book job, leading to a set 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 job is straightforward. All it is advisable to do is:
- Navigate to your current job
- Add a Energy BI job 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 following time your current knowledge pipeline runs, your Energy BI semantic mannequin will routinely 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 possibly can 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 strive immediately. To get began, please go to Energy BI job documentation.
Seeking to deepen your Energy BI + Azure Databricks integration?
Try Half 1 and Half 2 of our connectivity collection:
Collectively, these blogs present important greatest practices to optimize safety and efficiency when connecting Energy BI to Azure Databricks.
The Databricks crew is all the time trying to enhance the Energy BI integration expertise, and would like to hear your suggestions!