Forum Discussion

frithjof_v's avatar
frithjof_v
Community Champion
2 years ago
Solved

Small vs. Large Semantic Model Storage format

Hi,   I am wondering: Are there any benefits of using Small Semantic Model Storage format, or should we always use Large Semantic Model Storage format if we have Power BI Premium? Does the choic...
Need Help
  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    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 

     

Somu1234's avatar
Somu1234
Frequent Visitor
1 year ago

Hi All, In my workspace setting, under Semantic Model Storage Format, "Large Semantic Model Storage Format" is disabled. Could anyone tell why it is disabled and how to enable it.

 

lbendlin's avatar
lbendlin
Super User
1 year ago

There are no tenant settings that can block that, only this

 

What SKU are you running on?

  • Somu1234's avatar
    Somu1234
    Frequent Visitor
    1 year ago

    Hi,

     

    I found the solution. Only the capacity admins can enable the option in a workspace. Capcacity admins need to get access as workspace admins and then they can change the storage format.

     

    Thank you all.

     

    Regards,

    Somasundaram.S