How to refresh datasouce on demand via API

[SarahT]

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

[SarahT]

Thanks @lbendlin 

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

I'll explore Power automate 🙂

[lbendlin · Accepted solution]

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.