Forum Discussion

SarahT's avatar
SarahT
Frequent Visitor
1 year ago
Solved

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...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    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.

lbendlin's avatar
lbendlin
Super User
1 year ago

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.