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.
10 Comments
- https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/
- 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.
- 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.
- This feature is terribly important to us.
- Need this badly to automate end to end process
- 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
- 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.
- That feature would be very useful. Looking forward to have it!
- Yeah it is done! https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/
- Status added:Completed
