How to know dataset size with API?

[luanlopes]

Hey, 

I need to create a logic in my software but with my datasets, but i need to know the size of my dataset, how can i do that? 

[Murtaza_Ghafoor]

This is the standard API formar to get the data size 

https://api.powerbi.com/v1.0/myorg/groups/{workspaceId}/datasets

Or you can use fabric capacity metric app to check the size of of your data models/semantic models.

[danextian]

Hi @luanlopes 

I am not sure with API but you can check on system storage under workspace settings.

[luanlopes]

Yeah @danextian, I know about it but I want to check this point using some API (PowerBI or something like that) or CLI... 

[luanlopes]

Hey @danextian, thanks for the answer, but I'm trying to see the same number I see when I open the Workspace settings -> System Storage (API).

[lbendlin]

You need to take the quality and compressibility of your data into account.  There is a big difference across semantic models, and a big difference between disk size and memory size.

What are you ultimately trying to achieve?

[luanlopes]

Hi @lbendlin, 

Thanks for the reply I’m actually trying to retrieve that same number (shown under Workspace settings → System Storage) through an API.

[lbendlin]

Understood. But why? What are you doing with that number once you get it?

[luanlopes]

I will use this number in my rule business and is important to us...

[lbendlin]

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

[luanlopes]

I created a new suggestion about it -> https://community.fabric.microsoft.com/t5/Fabric-Ideas/Add-API-or-endpoint-to-retrieve-dataset-size/...

[v-priyankata]

Hi @luanlopes 

Thank you for reaching out to the Microsoft Fabric Forum Community.
@lbendlin @sergej_og @danextian @Murtaza_Ghafoor Thanks you so much all for your inputs.

@luanlopes Thank you for letting me know that you have submitted this as an idea.

Thanks.

[sergej_og]

Load the data into your model and save the file. Then look at the file size (.pbix) (compressed size).