Power Automate Exchange

Please login or click SIGN UP FOR FREE to create your FlowUG account to join this user group.
 View Only
  • 1.  How to Be Notified When an API Dataset Refresh Fails

    Silver Contributor
    Posted Nov 05, 2021 03:35 PM

    Hi Everyone,
    I have a Power Automate flow that once triggered, it refreshes a Power BI dataset using the "refresh a power bi dataset" connector.  When this runs, the flow will run correctly and kick off the refresh within Power BI. From the Power Automate side, everything has succeeded. However, on the Power BI side sometimes my refresh fails. I want to know if there is some type of way to send an email notification when the refresh fails on the Power BI service side. Because i'm using Power Automate to refresh the report, i can't go into the Power BI service and set up a refresh failure notification as I don't have "Scheduled Refreshes" set up. Any help would be much appreciated.


    Eric Leible
    Specialist - Service Management Analytics

  • 2.  RE: How to Be Notified When an API Dataset Refresh Fails

    Top Contributor
    Posted Nov 09, 2021 07:09 AM
    What I've done is add a status tracker to the dataset, most our reports all the logic is done in SQL and only the final results are pushed back to power bi.

    So as part of the procedure, I update a table with coulmns for report name and refresh completed. Refresh completed gets set to 0 and at the end of the procedure it gets set to 1.

    Then in power automate I set up a loop that polls this table every x seconds to wait for the completion. Then if you have a parallel branch with a delay for say x minutes longer than it should take to complete a refresh you can have an email action there to prompt you to check the report. Worst case scenario is you get a false alarm.

    Just be sure to put a terminate action after the "polling" query so if it actually completes, the job stops running and the email doesn't go out

    Sam Duval
    Data Quality Analyst
    Element Financial
    Indianapolis IN