There are many use cases to connect Power BI + Power Automate via the Power BI API.
- Refresh a solution on a different schedule than is available in the service (i.e. monthly on the 1st, not @ a specific time – triggered by the end of a variable ETL process, kicked off via PowerApps after a manual load of source data, etc.)
- Check status of refresh at any time
- Check gateway status
- Download pbix files and save to a shared drive
- and more!
If you want to add administration monitoring capabilities and notification to your Power BI environment or have the ability to connect and automate processes in your Power BI environment, Power BI + Power Automate is a great combination to utilize.
This is a custom connector created for connecting to the Power BI API from Power Automate (formerly Microsoft Flow) or Azure Logic Apps.
I had issues utilizing this one: https://github.com/microsoft/PowerBI-CSharp/blob/master/sdk/swaggers/swaggerV2.json
I did not have issues with this one: https://github.com/microsoft/powerbi-rest-api-specs/blob/master/swagger.json
To import from an OpenAPI / swagger file, follow the directions here: https://docs.microsoft.com/en-us/connectors/custom-connectors/define-openapi-definition
By far, this is the best article to follow on configuring your Power BI Custom Connector (after importing from swagger/OpenAPI file): https://medium.com/@Konstantinos_Ioannou/refresh-powerbi-dataset-with-microsoft-flow-73836c727c33
Take a look at the product and see if it would be valuable for you or your organization. It is available on vizbp.com:
Power BI + Power Automate API Connector
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: