Power BI + 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.
This download will include the Power BI + Automate API Connector (https://vizbp.com/downloads/power-bi-automate-api-connector/). At this time, Microsoft Flow/Automate packages do not include the customer connectors. Therefore, you will have to install the custom connector following the instructions on that page prior to importing this package in order for it to work.
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.
Download the solution
The solution can be downloaded from your account from vizbp.com after purchase.
- On vizbp.com, access the Customer Dashboard.
- On the sidebar menu, select Downloads.
- You will see all of your purchases and the download links for each.
Install the solution
The solution can be downloaded from your account from vizbp.com.
- Import the package following the documentation: https://flow.microsoft.com/en-us/blog/import-export-bap-packages/
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: