Coauthored by: Penny Zhou
Semantic Model Refresh Templates in Power BI enables you to orchestrate semantic model refreshes using Fabric Data pipelines. This feature allows you to visualize and sequence refresh activities for common and advanced scenarios.
You can access these templates by selecting Create advanced refresh from the refresh dropdown menu on the semantic model details page in your Microsoft Fabric workspace.
Create_advanced_refresh_preview_buttonThe template gallery includes several common refresh scenarios such as event-driven refreshes, refreshing a semantic model after a dataflow runs, scheduled refreshes, and sequencing multiple semantic model refreshes.
When you select a template, you can start a guided tour that walks you through the steps to set up a semantic model refresh.
Semantic_Model_Refresh_Templates_GalleryThe template gallery can be reopened from the pipeline ribbon in the Home tab by selecting the Use a template button.
Template_Gallery_ButtonLet’s dive in and see several examples for the following scenarios:
- Refresh semantic model after a dataflow refresh
- Incremental Refresh
- Adding an alert activity
- Schedule refreshes
- Sequence multiple semantic models
- Event driven or triggered refresh
Refresh semantic model after a dataflow refresh
You’ll be prompted to configure the dataflow and workspace you want refreshed.
Refresh_semantic_model_after_a_dataflow_refreshesFor the semantic model refresh settings, select the connection, workspace and semantic model to be refreshed.
Semantic_Model_Refresh_Activity_SettingsIncremental (Partition) Refresh
Choose specific tables or partitions for incremental refresh scenarios where only updated data is refreshed instead of the entire model.
Incremental_Refresh_for_Semantic_ModelsAdding an alert activity after semantic model refresh
Add additional activities, such as sending a Microsoft Teams or Outlook message, after a successful or unsuccessful execution. Select each activity to navigate to its settings.
Adding_a_teams_and_outlook_alert_activity_after_semantic_model_refreshScheduled refreshes
Schedule_a_semantic_model_refreshSet up scheduled refreshes to define when and how often they occur, with flexible intervals such as minute-by-minute, hourly, monthly, or quarterly.
When finished, select Save and Run to execute the pipeline.
Select_Save_and_Run_to_execute_the_pipelineSequence multiple semantic models
Use this template to refresh multiple semantic models in a workspace in sequence. The semantic model refresh activity allows you to connect to your Power BI semantic model datasets and refresh them from a pipeline. Configure the semantic model by selecting the connection, workspace, and semantic model to refresh. If you select tables, you can also choose partitions.Example:
- First refresh: Category tables
- Second refresh: TagName
First_refresh_Category_tablesSecond refresh: TagName
Second_refresh_TagNameEvent-driven or triggered refresh
This template enables you to set up an event that triggers a semantic model refresh. You can create rules on your real-time data within Fabric or externally. When a rule is activated, the selected action or notification is executed.Refer to the documentation to learn more about event-driven data pipelines in Microsoft Fabric.
Build_event-driven_data_pipelines_with_the_Trigger_buttonTo configure:
- Add activities to the canvas, rename the semantic model, add a description, and configure the activity state or timeout.
- Configure the semantic model settings: add a connection, select the workspace and semantic model, and choose tables or partitions (optional incremental refresh).
- Select Add Trigger and choose from Fabric or Azure events.
Try it out today!
Check out the Refresh a semantic model using data pipelines (preview) documentation to get started with semantic model refresh templates, powered by fabric data pipelines!Learn more about fabric data pipelines in the templates and semantic model refresh activity documentation.
Check out the Semantic Model Refresh Templates experience demo.
https://www.youtube.com/watch?v=AEXtSe2OA5E&t=511s
Provide Feedback
Please try out this preview and let us know what you think! We are interested in any and all feedback you have, but there’s a few areas we’re particularly interested in:- Examples of how you or others in your company would want to use this experience.
- How useful are you finding the feature? What could we add to make it more useful?
- Are there specific semantic model refresh templates you’d like to see in this experience?