Automatically refresh dataset when dataflow refresh completes – now with 100% less code!

Back in October I blogged about using PowerShell and/or the Power BI dataflows REST APIs to trigger a dataset refresh on dataflow refresh completion. This was a new capability and was well received… but lots of people wanted to do it without needing to write any code.

For those people, Christmas came early.

This week the Data Integration team at Microsoft announced the public preview of the dataflows connector for Power Automate.

This new Power Automate connector[1] will enable any authorized user to take action based on dataflow refresh completion, including:

  • Sending a notification – so you can keep additional users and groups informed
  • Trigger a dataflow or dataset refresh – so you don’t need to maintain separate refresh schedules or live with unnecessary processing delays
  • Trigger a Power Automate flow – so you can do pretty much whatever you want, because Power Automate has a ton of capabilities this blog post won’t even attempt to mention

You can also use the connector to refresh dataflows and monitor dataflow refresh status.

To make it even easier, the preview includes samples for these scenarios and more. You can read all about it and get started today in this post on the official Power BI Blog. What are you waiting for?


[1] Which uses the APIs mentioned in the earlier blog post.

3 thoughts on “Automatically refresh dataset when dataflow refresh completes – now with 100% less code!

  1. Pingback: Automatically refresh dataset when dataflow refresh completes – BI Polar

    1. PBailey

      We had to tell our admins to turn this ability on. The only thing I’m not understanding now is where all the body details are so that I can trigger the next step based on the Success/Failure of the refresh. These data does not show in PowerAutomate to me the way that MS shows in their whitepaper.

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s