Forum Discussion
Refresh Desktop Power BI model using Power Automate
Did you see https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/ ? Also the connector list https://us.flow.microsoft.com/en-us/connectors/shared_powerbi/power-bi/ which can take you to the documentation at https://docs.microsoft.com/en-us/connectors/powerbi/
You'll also want to pay attention to your API limits https://docs.microsoft.com/en-us/power-platform/admin/api-request-limits-allocations . I just learned yesterday that each action is an API call in https://youtu.be/TCIr7Bc3Oko which is JLevesque YouTube's with RezaDorrani as his guest.
Hi Chris,
Yes, I did actually try the PowerBI connector in Power Automate. The issue, though, is that I don't believe that it is actually refreshing the underlying data that the PowerBI model is using. The data for the PowerBI desktop model is actually coming from an external cloud database system that's capturing the data. When I do a refresh manually in PowerBI desktop, it takes approximately 5 minutes to refresh. Using the PowerBI connector in Power Automate though, the refresh is taking 44ms. It would be great if the refresh only took 44ms, but what I think is going on is that it's only refreshing what's already loaded into the PowerBI desktop model, but not doing the refresh with the underlying data from the external cloud database.
Warren