Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsMedium
A Power BI developer needs to implement a solution where a dataset's data is only refreshed after a specific event occurs in an external system (e.g., a data warehouse ETL process completes). The refresh should not be based on a fixed schedule. What Power BI feature should the developer use for this scenario?
- AProgrammatic refresh using Power BI REST API
- BScheduled refresh
- COn-demand refresh
- DManual refresh in Power BI Desktop
Show answer & explanationAnswer & explanation
Correct answer: A. Programmatic refresh using Power BI REST API
Programmatic refresh using the Power BI REST API allows external systems to trigger a dataset refresh based on specific events. This is ideal for scenarios where refreshes need to be event-driven rather than time-based, integrating Power BI into automated data pipelines.
Why the other options are wrong
- B. Scheduled refresh is time-based and does not respond to external events.
- C. On-demand refresh requires manual intervention in the Power BI service, which is not automated.
- D. Manual refresh in Power BI Desktop only refreshes the local model and does not affect the published dataset in the service.
Power BI REST API (Dataset Refresh)
The Power BI REST API includes endpoints that allow external applications or systems to programmatically trigger dataset refreshes, enabling event-driven automation and integration.
- Enables programmatic refresh
- Triggered by external systems/events
- Integrates with automated pipelines
- Requires API calls
Memory trick: The REST API listens for events to trigger the refresh.