Power Platform Community Forum Thread Details

I'm trying to automate the distribution of a Power BI report using Power Automate, but I need to ensure the semantic model refresh completes successfully before the flow runs. I tried adding the Refresh a dataset action to my flow, but it only submits the refresh request and the flow continues before the refresh completes. I also tried adding a delay, but since refresh times vary and a refresh could fail, that could still result in distributing a report with outdated data.

Everything I've found online recommends using the Power BI REST API to check the dataset refresh status/history. Unfortunately, my company blocks the HTTP with Microsoft Entra ID connector through our DLP policy. In addition, our company also blocks setting up Power BI data alerts.

Has anyone implemented a way to verify that a Power BI semantic model refresh completed successfully before continuing a Power Automate flow without using the REST API?

If so, I'd appreciate any suggestions, examples, or alternative approaches.

Categories:

Building flows

Using connectors

General topics