Skip to main content

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

ac643e7c e800-ea11-a811-000d3a4f1ebb 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

d7c9ea47 2310-4cd6-8516-2f93b35a1c8e 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

4a9fa078 a9bb-41a5-83a6-efb7f6900373 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

937d3bb8 2ffa-e711-8186-e0071b6ac181 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

8cb415e0 0fba-4b33-9a0a-e2875c3bb45a 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

8f56d128 4b12-42d4-a902-fc8f26f7d240 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

4e83bfae a57a-4f91-8074-0db51afee85a 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

e5a07102 4c53-46d6-95cb-70bff00e95e8 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.