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

  • frithjof_v's avatar
    frithjof_v
    Community Champion
    1 year ago

    I'm curious about the "This workspace is configured to use a capacity that you don't have access to" part