Problem Statement

Currently, the Finance and Operations – User License Consumption detailed report is available only through the Power Platform Admin Center (PPAC) and can be exported manually as a CSV file. There is no supported method to automate the export or directly integrate this data into Power BI.

For organizations that centrally manage licensing, governance, and compliance through Power BI, this creates a gap, as this critical report remains siloed outside the existing reporting ecosystem.

Business Requirement

Our organization maintains multiple Power BI reports to manage:

• License usage
• Azure AD / Entra ID security groups
• Role-based access and compliance
• Cost optimization and audits

A key business requirement is to centralize all license‑related reporting within Power BI, including the Finance and Operations user license consumption data that is currently available only in PPAC.

Specifically, we require:

• A supported, automated mechanism to access Finance and Operations user license consumption data
• Ability to refresh this data on a scheduled basis (for example, daily)
• Native or supported integration with Power BI (API, data connector, or Dataverse/Export to Data Lake option)

Current Limitation

• The report can only be exported manually by an administrator
• No API, connector, or scheduling capability exists today
• Manual downloads do not scale and are not suitable for enterprise reporting or audit automation

This limitation introduces:

• Operational overhead
• Risk of outdated or inconsistent reporting
• Fragmentation of license governance data

Proposed Solution / Ask

Provide one or more of the following supported capabilities:

• A Power Platform or Graph API to retrieve Finance and Operations license consumption data
• A native Power BI connector for Finance and Operations licensing data
• Ability to export this dataset to Azure Data Lake / Dataverse for reporting
• Built‑in scheduled export capability from PPAC

Business Value

• Centralized and consistent license governance reporting
• Reduced manual effort and administrative overhead
• Improved compliance, audit readiness, and cost optimization
• Better alignment with enterprise BI and FinOps practices

Impact

This enhancement would benefit:

• Large enterprises managing multiple Finance and Operations environments
• Organizations with strict compliance and audit requirements
• Customers using Power BI as a single source of truth for licensing and governance insights