How to know the size of each table of a dataset?

[degranadost]

I want to know How can I get the size of each table of a dataset in power bi. Quisiera saber como obtener la información de cuanto pesa cada tabla de un dataset en Power BI.

[AllisonKennedy · Accepted solution]

@degranadost  You can download the external tool DAX studio for free and get lots of info about your model that way: https://daxstudio.org/docs/features/model-metrics/ 

[Anonymous]

Hi @degranadost ,

Pls has your problem been solved? If so, accept the replies as a solution and I think solutions from Kedar_Pande and AllisonKennedy are both great. This will make it easier for the future people to find the answer quickly.

If not, please provide a more detailed description.

Best Regards,

Stephen Tao

[Kedar_Pande · Accepted solution]

1. Download DAX studio, if you don't have
2. Open your Power BI file and then open DAX Studio.
   Connect to your Power BI model.
3. Run the Size Query

   EVALUATE
   
   ADDCOLUMNS (
   
   SUMMARIZE ( 
   
   VALUES ( __Table__ ),
   
   __Table__[Name],
   
   "Row Count", COUNTROWS ( __Table__ ),
   
   "Size (KB)", COUNTROWS ( __Table__ ) * 8 / 1024
   
   ),
   
   "Total Size (KB)", [Size (KB)] * COUNTROWS ( __Table__ )
   
   )

This will give you the row count and an estimate of the size in kilobytes for each table in the dataset.

If this helped, a Kudos 👍or a Solution mark would be awesome! 🎉
Cheers,
Kedar Pande
Connect on LinkedIn

[AllisonKennedy · Accepted solution]

@degranadost  You can download the external tool DAX studio for free and get lots of info about your model that way: https://daxstudio.org/docs/features/model-metrics/