Forum Discussion
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 LearnThank you.
Hi _bs_
What you could do is set up a para automate flow which will trigger a refresh of the semantic model using. Request step (which is an HTTPS endpoint) as the source for your power automate flow, which you can then call when running is SSIS. You could follow my blog post link below and change the initial step to be a HTTP request: Using Power Automate to schedule a refresh of a Power BI dataset at the time you want! - FourMoo | Microsoft Fabric | Power BI
Thank you GilbertQ , could you expand on the call the P.A from within SSIS?
Which SSIS task would I need and how to reference the P.A.
Thanks
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.