Skip to main content
Microsoft Idea

Power BI

Completed

Add REST API to refresh data sources

Vote (80) Share
Scott Senkeresty's profile image

Scott Senkeresty on 25 Jun 2016 23:26:10

My SQL database does processing each night, and when it is "done", I want to kick off a refresh of my dashboards... but there is no way to do this.

Need to add a REST API to kick off a refresh of a data source.

Administrator on 22 Jun 2017 11:42:45

https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/

Comments (8)
Scott Senkeresty's profile image Profile Picture

sadf sdf on 05 Jul 2020 22:51:46

RE: Add REST API to refresh data sources

Yeah it is done!
https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/

Scott Senkeresty's profile image Profile Picture

Marcelo Navarro on 05 Jul 2020 22:50:23

RE: Add REST API to refresh data sources

That feature would be very useful. Looking forward to have it!

Scott Senkeresty's profile image Profile Picture

Aaron Steers on 05 Jul 2020 22:48:10

RE: Add REST API to refresh data sources

This is critical to our use cases as well. Without this, we spend way more time than necessary manually re-running refreshes, and we can't write any code that detects a refresh failure to notify the team. I imagine by adding this to the API, we would hopefully also be able to return (or poll for) a success/failure status after the refresh completes.

Scott Senkeresty's profile image Profile Picture

Eric Snyder on 05 Jul 2020 22:45:24

RE: Add REST API to refresh data sources

I have an Azure function that updates input data daily, and to avoid n +/- 1 problems in refresh sync, I need that function to kick off PowerBI datasource refresh ... I'll see you guys at //BUILD about this. Keep up the good work, Thx

Scott Senkeresty's profile image Profile Picture

Kapil Jain on 05 Jul 2020 22:44:55

RE: Add REST API to refresh data sources

Need this badly to automate end to end process

Scott Senkeresty's profile image Profile Picture

shargrove@haiint.com on 05 Jul 2020 22:43:55

RE: Add REST API to refresh data sources

This feature is terribly important to us.

Scott Senkeresty's profile image Profile Picture

Václav Haramule on 05 Jul 2020 22:40:38

RE: Add REST API to refresh data sources

This is really necessary for applications where you need realtime updates with predefined report created in Power BI desktop.

Cm'n this should be easy to implement.

Scott Senkeresty's profile image Profile Picture

andgarc on 05 Jul 2020 22:28:02

RE: Add REST API to refresh data sources

The ability to trigger the refresh manually via the API allows more robust data pipelines and ensuring customer always sees the latest data.

One alternative right now is to schedule a bunch of refreshes throughout the day so at worst a customer has a 2-3 hour lag - this just causes extra load on the service.