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 immediately from Databricks. This results in higher whole value of possession, increased effectivity, and ensures information is up-to-date for Energy BI report and dashboard customers.
Key advantages embrace:
- Direct integration: Publish datasets from Unity Catalog to Energy BI immediately from information pipelines.
- Replace Energy BI when your information updates: Considerably scale back refresh prices by updating semantic fashions solely when information modifications.
- Knowledge freshness for BI: Ship contemporary insights by robotically pushing modifications to underlying tables and their relationships.
Automate information integration from Unity Catalog with Energy BI
With the Energy BI activity, now you can automate Energy BI semantic mannequin updates and refreshes immediately from Databricks Workflows. This eliminates the necessity to swap contexts between Databricks and Energy BI, streamlining the method of constructing your information obtainable for visualization and evaluation in Energy BI.
Energy BI duties totally help Unity Catalog information objects together with tables, views, materialized views, and streaming tables. One of the best half – you possibly can construct Energy BI semantic fashions primarily based on Unity Catalog information 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 complete suite of governance and observability capabilities that Unity Catalog presents. This integration enhances safety and compliance by offering seamless authentication, authorization, and information 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 lengthen highly effective options comparable to activity dependencies, schedules/triggers, retries, and notifications to information 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 stability efficiency and safety.
Extensibility is entrance and heart with Energy BI duties. You’ll be able to work with Energy BI duties visually within the Databricks Jobs UI in addition to programmatically through the Jobs API and Databricks Asset Bundles.
The way it works
State of affairs: You have got an current retail analytics information pipeline that ingests information 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 information because it modifications over time.
Making a Energy BI activity is easy. All it is advisable to do is:
- Navigate to your current 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 information objects
- Set an authentication technique
- Save the duty
Now the following time your current information pipeline runs, your Energy BI semantic mannequin will robotically replace as your information modifications.
Inside seconds of your job efficiently finishing, your dataset might 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 information engineers to supercharge their information 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 provide them a attempt immediately. To get began, please go to the Energy BI activity 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 finest practices to optimize safety and efficiency when connecting Energy BI to Azure Databricks.
The Databricks staff is at all times trying to enhance the Energy BI integration expertise, and would like to hear your suggestions!
