Refresh semantic models after ETL

Hi _bs_,

Thank you tayloramy GilbertQ, for your insights,

With Power BI Pro, it's recommended to use Power Automate to trigger a dataset refresh instead of directly accessing the Power BI REST API. You can set up a Power Automate flow with an HTTP trigger, which SSIS can call after ETL finishes using an Execute Process Task (like PowerShell or curl) or a Script Task (C#/VB). Power Automate will then refresh the semantic model, keeping within Pro refresh limits.

Data refresh in Power BI - Power BI | Microsoft Learn
Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn
Execute Process task - SQL Server Integration Services (SSIS) | Microsoft Learn
Script Task - SQL Server Integration Services (SSIS) | Microsoft Learn

Thank you.