Currently, Power BI administrators do not have a scalable and programmatic way to extract refresh history across the entire tenant using Admin APIs with a service principal. This limitation creates significant challenges for centralized monitoring, governance, and operational reporting of dataset and dataflow refresh activities. Proposed Enhancement: Enable a dedicated Admin API endpoint (or extend existing ones) that allows tenant-level extraction of refresh history for datasets and dataflows, accessible using a service principal (app-only authentication), without requiring delegated user context. Key Requirements: Support tenant-wide refresh history extraction across all workspaces (including personal and shared workspaces where applicable). Allow service principal authentication to ensure automation, scalability, and secure integration with enterprise monitoring tools. Provide granular refresh details, including: Dataset/Dataflow name and ID Workspace name and ID Refresh start and end timestamps User name or Email Status (Success/Failure) Error messages and failure reasons Trigger type (scheduled, manual, API, etc.) Support incremental extraction (e.g., via datetime filters) to enable efficient data ingestion pipelines. Ensure pagination and performance optimization for large tenants. Business Value: Enables enterprise-grade monitoring and alerting solutions beyond current UI limitations Improves data reliability and SLA tracking across BI environments Supports audit, compliance, and governance use cases Reduces dependency on manual exports or fragmented workspace-level API calls Aligns with industry best practices for automation-first administration Current Challenges Without This Feature: Admin APIs today provide limited or workspace-scoped insights, requiring iterative and inefficient API calls Lack of service principal support restricts automation and forces reliance on user-based authentication No unified way to build a centralized refresh monitoring dashboard across the tenant Expected Outcome: A robust, scalable, and secure Admin API capability that empowers organizations to programmatically retrieve and analyze refresh history data at tenant level, unlocking advanced BI operations, observability, and governance.
... View more