Power BI + Power Automate Refresh Trigger
Need to trigger a refresh on a Power BI solution? Want to trigger a refresh based on a completed ETL run or when a file is created in a SharePoint directory? Want to notify the dataset owner when the refresh begins, when it completes successfully, or only when the refresh fails? The ability to trigger a refresh not based on a schedule but on a variable trigger and notify the owner of the dataset if the refresh fails is critical to an optimized environment and environment oversight.
There is a new Microsoft Automate (Microsoft Flow) action to refresh a Power BI solution. So, what does this solution do that is different from that solution?
With a Power BI triggered refresh via the API, there is no notification if there is a failure. This solution:
- Allows for sending a notification when a refresh is triggered.
- Checks the status of the manual refresh every 5 minutes (configurable).
- Allows for emailing the owner on success.
- Allows for emailing the owner on failure.
- If you capture the initiator of the trigger, you can email that person when triggered and upon success/failure.
This solution will be updated periodically as new feature requests and other thoughts on what could be added to improve the solution. Make sure you’re running the latest version. The application will have a version displayed and notify you if there is a new version available.
Take a look at the product and see if it would be valuable for you or your organization. It is available on vizbp.com:
While there, take a look at other solutions people like me are making available for free or for purchase. Take a look at becoming a seller yourself and offering your solutions in the marketplace.
While here, take a look at my other articles related to vizbp.com: