Fabric Capacity Questions

[reddyrkiran]

• Is the maximum size of a semantic model on an F64 Fabric capacity limited to 25 GB? If so, is there any way to increase or work around this limit?
• Is the maximum memory per query for an F64 capacity limited to 10 GB? If so, are there any options to increase this limit or work around it?
• Price options if we go with F16 and use Reservation and then we feel we need to go to a different SKU F32 or F64 is it possible or to be able to make this change should we be in "Pay as you go" model?

[Deku · Accepted solution]

Model size is 25gb

https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is#semantic-model-sku-lim...

Query limit is 10gb

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-premium-workloads#query-memory-l...

Both of these cannot be increased 

Here is some info on resizing on a reservation

https://learn.microsoft.com/en-us/azure/cost-management-billing/reservations/fabric-capacity#increas...

[v-sgandrathi]

Hi @reddyrkiran,

Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

Thank you.

[v-sgandrathi]

Hi @reddyrkiran,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[amitchandak · Accepted solution]

@reddyrkiran , Already @Deku has shared, My comments

• Is the maximum size of a semantic model on an F64 Fabric capacity limited to 25 GB? If so, is there any way to increase or work around this limit?
  • Max Model size is unlimited, 25 GB is the paging limit, refer screenshot below https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview
• Is the maximum memory per query for an F64 capacity limited to 10 GB? If so, are there any options to increase this limit or work around it?
  • NO
  • Price options if we go with F16 and use Reservation and then we feel we need to go to a different SKU F32 or F64 is it possible or to be able to make this change should we be in "Pay as you go" model?
    You can upgrade the Next capacity. Work with your Partner or Microsoft Manager.

[xZLeni127]

• ---

  @amitchandak wrote:
  

  @reddyrkiran, Already @Deku has shared, My comments
  
  

  • Is the maximum size of a semantic model on an F64 Fabric capacity limited to 25 GB? If so, is there any way to increase or work around this limit?
    • Max Model size is unlimited, 25 GB is the paging limit, refer screenshot below https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-overview
  • Is the maximum memory per query for an F64 capacity limited to 10 GB? If so, are there any options to increase this limit or work around it?
    • NO
    • Price options if we go with F16 and use Reservation and then we feel we need to go to a different SKU F32 or F64 is it possible or to be able to make this change should we be in "Pay as you go" model?
      You can upgrade the Next capacity. Work with your Partner or Microsoft Manager.

  

Wow, this is very useful information, especially about the 25 GB limit, it turns out that it is only a paging limit, not a model size limit. So you can explore more freely. The question of upgrading SKU from F16 to a higher one is also quite flexible, as long as it is coordinated with a partner or Microsoft Manager.

[Deku · Accepted solution]

Model size is 25gb

https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is#semantic-model-sku-lim...

Query limit is 10gb

https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-premium-workloads#query-memory-l...

Both of these cannot be increased 

Here is some info on resizing on a reservation

https://learn.microsoft.com/en-us/azure/cost-management-billing/reservations/fabric-capacity#increas...