Forum Discussion
Small vs. Large Semantic Model Storage format
- 2 years ago
Hi frithjof_v ,
As per my knowledge,there will be no impact on your storage if you are using direct lake or direct query.So, you don't have to worry about it as the data will be processed by only power bi engine when you are interacting with your reports as there will be no intermediate data staging on the semantic model.
I hope I have answered your query.
Thanks,
Sai Teja
Hi frithjof_v ,
Large Semantic model comes with additional capabilities to handle large volume of data.
As per my knowledge ,direct lake mode is a capability of semantic model.If you are using direct lake mode then the data will be directly loaded to power bi engine and gets processed.
You can refer below links for more details
https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-large-models
https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview
Thanks,
Sai Teja
- frithjof_v2 years agoCommunity Champion
Will the choice between small or large semantic model storage format affect how much data a Direct Lake query can handle before it reaches it's limit (falls back to DirectQuery)?
Or is the choice between small and large semantic model storage format only relevant when using import mode semantic model?
- SaiTejaTalasila2 years agoSuper User
Hi frithjof_v ,
As per my knowledge,there will be no impact on your storage if you are using direct lake or direct query.So, you don't have to worry about it as the data will be processed by only power bi engine when you are interacting with your reports as there will be no intermediate data staging on the semantic model.
I hope I have answered your query.
Thanks,
Sai Teja
- lbendlin2 years agoSuper User
Only relevant for the import mode queries in your semantic model.