topic Re: How to refresh datasouce on demand via API in Developer

How to refresh datasouce on demand via API

SarahT — Mon, 09 Sep 2024 09:47:51 GMT

Hello community

Sorry for my english 😞

The use case is :

My key user must refresh datas at any moment.

I want him to be independant to launch this execution.

I'd like to use API refreshes, but i don't how to do to chain the step.

For example :

Step 1 - Generate token

Step 2 - Refresh datasource

Step 3 - Refresh dataflow

Step 4 - Refresh dataset

How i can make sure that the first step is done before the second step go.

Has anyome has implemented this case

Thanks

Re: How to refresh datasouce on demand via API

lbendlin — Mon, 09 Sep 2024 13:18:24 GMT

Step 2 is outside of the scope of Power BI. Steps 3 and 4 can be done with Power Automate, but you must keep in mind that these refresh requests are asynchronous. You would need to implement your own polling, especially to monitor step 4.

While we have implemented just such a use case, the user experience is horrible. Users expect to see immediate results when they hit the button. NONE of these steps give immediate results. It's one big guessing game of if and when it completes.

Re: How to refresh datasouce on demand via API

SarahT — Mon, 09 Sep 2024 13:30:39 GMT

Thanks @lbendlin

It's a good argument 🙂 and i'm aware that the result is not immediat.

I'll explore Power automate 🙂