topic Refresh PowerBi pending on predecessors in Report Server

Refresh PowerBi pending on predecessors

wouterDefour — Tue, 17 Dec 2019 08:08:35 GMT

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

Re: Refresh PowerBi pending on predecessors

d_gosbell — Wed, 18 Dec 2019 00:06:03 GMT

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/ )

Re: Refresh PowerBi pending on predecessors

wouterDefour — Wed, 18 Dec 2019 10:09:32 GMT

Thanks!

Setup is very easy and works perfertly.