Refresh PowerBi pending on predecessors

[wouterDefour]

Hello,

I have a powerBI which I would like to refresh. 

The refresh should be done when the datasets are up to date. 

There is no fixed time when all the datasets are up to date. they are all ready between 6h30 and 7h30.

Imho a pushed refresh is the best solution. I tried two ways of working:

- through rest API

- placing a blob on azure storage website

Both are very hard to configure in azure portal and we fail each time on security.

We do not have the authority to perform certain actions when configuring in azure, also our admins in our company do not want to grant the rights because of security reasons.

I was think of sheduling the powerBI each 15 minutes between 7 and 9am, but letting it fail when the datasets are not ready.

Does any one have any ideas how to accomplish this?

Any other suggestion is appreciated!

Thanks for your insights,

Wouter

[d_gosbell · Accepted solution]

Have you looked at using Power Automate ( which used to be called Flow ) It has a task to trigger a Power BI refresh. So it you can detect when your datasets are updated somehow you could then use Power Automate to trigger the Power BI refresh (see https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/ )

[wouterDefour]

Thanks!

Setup is very easy and works perfertly.