Power BI Report/Dataset Sizes - for All reports

[KarenL7]

Hi

I know how find out the sizes of dataset sizes of reports which  using the following method -

https://community.fabric.microsoft.com/t5/Service/How-do-I-check-the-size-of-a-dataset-published-to-...

Ideally we would like to look at the dataset sizes of all report across all of our workspaces so we can see which reports are largest and then start at approaching people about tuning there datasets if necessary - so would like this in a report which we can see rather than checking every single workspace for this information.

Another admin gave me access to a capacity metrics report with storage but it is only showing 2 workspaces and not really helping?

Should I install the capacity metrics app and then investigate that way?  Or is there are another way to look in the admin portal.

Thanks

Karen

[KarenL7]

As a question - I looked at dataset sizes in the workspaces under > system storage - but it is showing 0mb  - I understand 0mb owned by me for this workspace but not 0mb for the workspace when it is clearly not 0mb for the workspace.

Not sure if I should have started a new topic for this!

[Joe_Barry]

Hi @KarenL7 

If you have Power BI Admin rights you can install The Fabric Capacity

• Metrics App > Apps > Search "Micorosft Fabric Capacity Metrics"
• You will be promted to enter the Capacity ID which can be found in Power BI Admin Portal > Capacity Settings > Settings
• Then also to sign in
• Then the App will be installed
  
  When it populates then data per workspace will be available
  
  Hope this helps
  Joe
  

[KarenL7]

Hi @Joe_Barry 

Thanks for this - the report looks familiar to one that I wsa provided access to - but only showed 2 workspaces.  I will install the app - thanks -

Just as a quick question do you know if I can I set permissions on the app so it only shows for particular users?

Thanks

Karen

[aj1973]

Hi @KarenL7 

Capacity metrics only shows workspace items of workspaces in premium capacity only .

You need to build a report using Power BI Rest APIs

[KarenL7]

Hi @aj1973 

Thanks for your reply -I have had a quick look at the dataset APIs, howver when I looked at a number of the dataset ones I cannot see dataset sizes

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-datasets

Do you know which one I can use at all?

Thanks

Karen