Native Tenant-Wide Metadata/API for Semantic Model "Offline Size"
The Problem: Currently, there is no centralized way for a Fabric or Power BI Administrator to extract the offline (compressed disk) size of all semantic models across a tenant. While individual sizes can sometimes be found via the XMLA endpoint or by manually checking the Capacity Metrics App, there is no REST API or Scanner API attribute that exposes this data at scale.
Microsoft has previously noted that this information is not currently exposed in any API. This creates a significant blind spot for administrators who need to:
Manage Capacity Growth: Identify which models are approaching the "Max Offline Dataset Size" limits set in the Admin Portal.
Optimize Costs: Pinpoint bloated models that are consuming excessive storage or will require large memory footprints upon loading.
Proactive Governance: Automate reporting on tenant-wide storage trends to prevent capacity exhaustion before it happens.
The Proposed Solution: Update the Power BI/Fabric Admin REST APIs (specifically the Scanner API or Get Datasets In Group) to include a metadata field for offlineSizeInBytes.
Ideally, this should provide:
The compressed size on disk (Offline Size).
Integration with the Fabric Capacity Metrics App: A dedicated, exportable table showing the size of all items, not just those recently active.
Historical Snapshotting: The ability to see how a model's offline size has grown over time via standard admin logs.
Why this is important for Fabric: As we move toward a more unified Fabric experience, storage and compute are billed and managed more strictly. Knowing the "weight" of a semantic model before it is loaded into memory is a fundamental requirement for any enterprise-grade "Flight Dashboard." We cannot manage what we cannot measure at scale.
Recent ideas
Make Copilot Approval status for semantic model available through API
In recent versions fabric allowed to mark a semantic model as approved for copilot to reduce AI adoption friction. However there is no specific way for external governance application to analyse whi...FrançoisD10 minutes agoFrequent VisitorNew1View0likes0CommentsClone a workspace, including its data, to a new workspace
Description: Today there's no way to fully clone a Fabric workspace: git sync and Deployment Pipelines move item definitions only, not the underlying data; Warehouse's zero-copy CREATE TABLE ... AS ...gclements1 hour agoHelper IINew6Views1like0CommentsAllow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara6 hours agoNew MemberNew7Views0likes0CommentsSupport Synonyms in Fabric Warehouse
Microsoft SQL Server has a very powerful feature by the way of "synonyms." It allows users and DBAs to do all sorts of powerful magic such as rewiring objects under the hood (e.g. run the code agains...matthias-bi10 hours agoRegular VisitorNew1.3KViews18likes2CommentsExpose Refresh Warnings and Informational Messages via Notifications and API
When a Power BI semantic model refresh completes successfully, the status shows Completed, even when the refresh details contain warnings or informational messages that require attention. Please pro...Jashwanth_K12 hours agoMicrosoft EmployeeNew27Views7likes0Comments