PowerBI Embedded

[adojeda86]

I'm trying to get a report to refresh as soon as an user enter changes in an excel file (using Flow). Users can make changes to the file multiple times a day and changes will exceed the 8 refreshes a day limit in PoworBI Pro.

I'm looking for an option to remove this limitation and added an Azure resource for PorwerBI Embedded. This seems to address my issue and my refreshes are actually ruining faster. However, when reading the PowerBI Embedded documentation, it looks like the PowerBI Embedded resource is meant for you to add PowerBI report to custom applications.

I don't plan to us custom apps and I'm currently distributing reports via the PowerBI app.

Looking for recommendations on the appropriate use of PowerBI Embedded Azure resource. My main goal is to remove the refresh limit in PowerBI service and it looks like this Azure resource met that requirement. Am I using this right?

[Anonymous]

@adojeda86 Do you have any specific links to what you are using? Is there a reason you aren't just calling the Power BI refresh API from Flow? Example: https://medium.com/@Konstantinos_Ioannou/refresh-powerbi-dataset-with-microsoft-flow-73836c727c33

or just recently they added this blog as an option - https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

[adojeda86]

Hi @Anonymous 

I'm using Flow to trigger the on demand refresh. It was my understanding that I am limited to 8 refreshes a day, so I'm looking to removed this restriction.

this is one of the limitations from the second link you shared:

Existing limits on refreshes apply when running the refresh dataset action in Microsoft Flow.  For datasets in shared capacity used by Power BI Pro, your refresh action is limited to eight refreshes per day (including refreshes executed via Scheduled Refresh). In Premium capacities, there is not limitation on the number of refreshes per day, although you are limited by the available resources in your capacity.  If there are not sufficient resources, the refresh execution may be throttled until the load is reduced. If this throttling exceeds 1 hour, the refresh will fail.