Forum Discussion
How to refresh datasouce on demand via API
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
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.
2 Replies
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.
