Description

Take full control over your semantic model refresh automation. Usually, in your daily planning there’s a gap between your data source data availability and the scheduled refresh on the Power BI service. This is caused by the impossibility to directly connect the semantic model refresh to a pipeline.

How to bridge that gap? How to trigger a Power BI semantic model refresh as the final step of a full ETL process? There are several ways to achieve it. It is possible to invoke the Power BI APIs in combination with tools such as Power Automate, or to run some Powerhell scripts, for example.

Furthermore, you can go deeper with the Dataset API, triggering only a specific table or even a single partition. Not the full semantic model, saving time and resources on your system.

In this heavily demo-based session, many examples of automation are showcased based on real cases of implementation in Pandora. You will see how to:

• Trigger a semantic model refresh using Power Automate
• Post a semantic model refresh using Power BI API and Power Automate
• Post a semantic model refresh from Logic App
• Trigger a semantic model refresh using Powershell
• Trigger a single table or partition refresh in your semantic model using XMLA endpoint and SSMS
• Handle advanced incremental refresh with the XMLA endpoint and the Tabular Model Scripting Language
• Trigger a single table or partition refresh in your semantic model using the enhanced dataset API
• Trigger a refresh from an Azure Data Factory / Synapse Analytics pipeline!

Speaker

Andrea Martorana Tusa

MVP Data Platform - Product Manager at Pandora

Andrea Martorana Tusa works for Pandora, a jewelry brand based in Copenhagen (DK).
Product Manager for the common Content Management platform built on Sharepoint.
Co-admin of the company's Power BI tenant with duties of governance, monitoring and auditing.
Solution Owner for the Data Analytics and Identity Access Management Azure platform. Common speaker in events and conferences around Europe and author for sqlservercentral.com, sqlshack.com, UGISS (User Group Italiano SQL Server).