Forum Discussion

vivianecechetti's avatar
vivianecechetti
Frequent Visitor
1 year ago
Solved

Dataset size for measuring Fabric Capacity

Hello everyone. I'm looking for a method to retrieve the sizes of all my datasets, with the aim of measuring them and estimating the necessary Fabric Capacity. Is there an API or another approach to obtain this information for all semantic models/dataflows within a tenant?

 

I'm current using this calculator: https://www.microsoft.com/en-us/microsoft-fabric/capacity-estimator

Need Help
  • ibarrau's avatar
    ibarrau
    1 year ago

    Hi. Sadly, there is no request like that at the Rest API. If you don't have a lot of workspace and semantic models you can check that manually. Open a workspace and go to Workspace Settings. There is a Storage setting showing the values of the sizes.

    If you have a lot workspaces, think about the highest sizes you could have and the smallest. Check the amount of semantic models at the Admin Workspace Purview Item views.. Build a measure that could let to a semantic model average size. Use that average and the amount of semantic models as reference for the Capacity estimation.

    I hope that helps,

2 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    1 year ago

    Hi. Sadly, there is no request like that at the Rest API. If you don't have a lot of workspace and semantic models you can check that manually. Open a workspace and go to Workspace Settings. There is a Storage setting showing the values of the sizes.

    If you have a lot workspaces, think about the highest sizes you could have and the smallest. Check the amount of semantic models at the Admin Workspace Purview Item views.. Build a measure that could let to a semantic model average size. Use that average and the amount of semantic models as reference for the Capacity estimation.

    I hope that helps,

  • SaiTejaTalasila's avatar
    SaiTejaTalasila
    Super User
    1 year ago

    Hi vivianecechetti ,

     

    You can try pulling those details from the Fabric Capacity Metrics report. Connect to the XMLA endpoint of the workspace and use DAX Studio to extract the information from the model. Alternatively, you can add a new page to your existing metrics report, create a table visual, and export the data. Refer to the performance matrix in the first page it will help.

     

    I hope it helps.

     

    Thanks,

    Sai Teja