How to get the size of all the datasets and dataflows in all the workspaces?

[sreedhary]

Hi,

I am trying to find the size of all the datasets and Dataflows from all the workspaces in my Power BI tenant. I know there is System Storage option for Individual Workspace. But, I need for all workspaces. is there an option or report?

Thanks for your help.

[sreedhary]

Thanks Sai. Yes, I used Fabric Capacity metrics App for datasets/semantic models. Unfortunately, we don't get size info for Dataflows from the metrics report. 

Thank you again.

[SaiTejaTalasila]

Hi @sreedhary ,

You try to get those details from fabric capacity metrics semantic model.You can use dax studio or run a query against dataset in power automate and you pull that data.As per my knowledge you can identify maximum storage taking dataset details easily from it.(Performance delta table)

Thanks I hope it will be helpful.

Thanks,

Sai Teja 

[SaiTejaTalasila · Accepted solution]

Hi @sreedhary ,

If your workspace type is premium then you will be able connect to xmla endpoint and using daxstudio you can pull the data.It's possible but the model will be little complex.

Thanks,

Sai Teja