Forum Discussion
Why does Power BI Service report different System Storage for two semantic models identical
Hi everyone,
I'm investigating an unexpected difference in Power BI Service → Workspace → Settings → System Storage between two semantic models.
Both models were created from the same PBIX. The only difference is the data source:
- Model A → Amazon Redshift
- Model B → ClickHouse
To verify that the models are equivalent, I compared them using DAX Studio (VertiPaq Analyzer).
Comparison results
- Same number of rows (~25.9 million)
- Same tables
- Same columns
- Same partitions (1 partition, 25 segments)
- Same column cardinality
- Nearly identical table sizes
- Nearly identical dictionary sizes
- Nearly identical relationship sizes
- Overall VertiPaq size differs by only a few MB
I also verified that:
- Both models refresh successfully.
- Both were published to a brand-new empty workspace.
- The same behavior occurs in the new workspace.
However, Workspace → Settings → System Storage reports significantly different storage usage for the two semantic models.
Since the VertiPaq models are almost identical, I expected the System Storage values to also be nearly identical.
My questions
- What exactly is included in System Storage besides the VertiPaq model?
- Is System Storage expected to depend on the data source connector (Redshift vs. ClickHouse)?
- Are processing artifacts, refresh snapshots, internal metadata, indexes, or other service-side objects included in this calculation?
- Has anyone observed similar behavior where two nearly identical semantic models consume different System Storage in Power BI Service?
I've exhausted the usual optimization checks (cardinality, dictionaries, partitions, relationships, VertiPaq size), so I'm trying to understand whether this is expected behavior or if there's another storage component that VertiPaq Analyzer does not expose.
Any insights or references to Microsoft documentation would be greatly appreciated.
Thank you!
Hi everyone, thank you for all your suggestions. I found the issue—it was the workspace setting for Large Semantic Models. I changed it back to Small, and it immediately returned to its original size.
5 Replies
- MohamedFowzan1Super User
Hi Georma
As far as I'm aware, Microsoft hasn't documented a detailed breakdown of the System Storage metric or exposed it through XMLA, REST APIs, or the Admin APIs. So while it's reasonable to assume it includes more than just the VertiPaq model, there's no supported way to attribute the reported storage to specific components.
I think we will need a microsoft ticket to confirm whether the connector influences the service's internal storage accounting as i have seen a similar un answered question previously when it comes to this
- v-csrikanthCommunity Support
Hi Georma
We would like to inquire whether have you got the chance to check the solutions provided by GilbertQ MohamedFowzan1 in community to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community. - GeormaNew Member
Hi everyone, thank you for all your suggestions. I found the issue—it was the workspace setting for Large Semantic Models. I changed it back to Small, and it immediately returned to its original size.
- v-csrikanthCommunity Support
Hi Georma
Thanks for letting us know that your issue has been resolved.
if you have any other issues realted to Fabric and PowerBI do post your queries in community.