Skip to main content
Microsoft Idea

Developer APIs

Completed

Trigger refreshes for datasets using API

Vote (224) Share
Power BI User's profile image

Power BI User on 11 Aug 2015 00:42:25

Instead of refreshing a dataset based on a schedule, I would like to trigger running a refresh on demand. A REST API that I could use to get the history of refreshes, current status of refresh, and start a refresh would be helpful.

Comments (14)
Power BI User's profile image Profile Picture

Jason E on 05 Jul 2020 22:45:07

RE: Trigger refreshes for datasets using API

I honestly can't believe some kind of conditional refresh doesn't already exist. Who has a data source with a guaranteed "ready" time every day? I don't know anyone who does. Refreshes should be conditional based on when the data is ready, not based on an arbitrary fixed time. Allowing a trigger of a refresh via the API would solve this problem.

Power BI User's profile image Profile Picture

Kapil Jain on 05 Jul 2020 22:43:42

RE: Trigger refreshes for datasets using API

Can we include it asap.....see the votes

Power BI User's profile image Profile Picture

Daniel on 05 Jul 2020 22:42:08

RE: Trigger refreshes for datasets using API

yes, why wasn't this included in the first place

Power BI User's profile image Profile Picture

Power BI User on 05 Jul 2020 22:40:23

RE: Trigger refreshes for datasets using API

Must have

Power BI User's profile image Profile Picture

Justin Stadler on 05 Jul 2020 22:39:55

RE: Trigger refreshes for datasets using API

Is there another item like this that is getting MS attention. To me this is a huge miss from enterprise perspective.

Power BI User's profile image Profile Picture

Mark on 05 Jul 2020 22:37:27

RE: Trigger refreshes for datasets using API

This would help immensely as we can then trigger a dashboard refresh once all the SQL Server Agent jobs have finished running.

Power BI User's profile image Profile Picture

Alex on 05 Jul 2020 22:33:04

RE: Trigger refreshes for datasets using API

Must have

Power BI User's profile image Profile Picture

sushil on 05 Jul 2020 22:26:36

RE: Trigger refreshes for datasets using API

This feature will be a great addition and will help generating real-time reports on data. scheduled refresh (8 times a day) does not give an insight of Data through out the day in real time. Will be a lot more helpful if refreshes can be made via API calls

Power BI User's profile image Profile Picture

Zach Fransen on 05 Jul 2020 22:24:57

RE: Trigger refreshes for datasets using API

Would be an excellent feature addition, we end up updating much later than we could because of the inability to link our ETL to the refresh.

Power BI User's profile image Profile Picture

Satish Reddy Patlolla on 05 Jul 2020 22:19:46

RE: Trigger refreshes for datasets using API

This feature is a must, as it is important in few of the cases to sequentialize your ETL runs and the power bi dataset refreshment