Forum Discussion
Solved
Refresh semantic models after ETL
Hello, I'd like to move away from scheduled refreshes of the Power BI semantic model and make it dynamic - so after the ETL has successfully refreshed. The Setup we have is: Workspaces use Power...
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 LearnThank you.
