Tables volume of data

[Anonymous]

Hi to everybody, 

I have a client who wants to know which data size are we loading on Power BI. Is there a way to know the size of the table in Power BI (like when you consult Properties to know a file size)?

Thanks in advance, 

Alejandro

[SpartaBI · Accepted solution]

@Anonymous are you familiar with dax studio and its view metrics feature?

[v-eqin-msft]

Hi @Anonymous ,

Agree with @SpartaBI that you need use DAX Studio.

1. In DAX studio ,select the PBI Desktop file you have opened:

Then execute such SQL statement that will fetch the table size information:

SELECT dimension_name AS tablename,

attribute_name AS columnname,

datatype,(dictionary_size/1024) AS size_kb

FROM $system.discover_storage_table_columns

WHERE dictionary_size > 0

For more information, please kindly take a look at the blogs:

Data Model Size with VertiPaq Analyzer - SQLBI

Extract Table Size from Power BI Desktop Using DAX Studio - Excelerator BI

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PC2790]

Hey @Anonymous ,

See if the similar thread helps-Solved: Re: How do I check the size of a dataset published... - Microsoft Power BI Community

[Anonymous]

Hi @PC2790 , 

It's similar to my problem, but the thing that I want to know is the size of each table in the dataset, not the size of the dataset. I don't know if this is possible. 

Anyway, thanks for the info. It could be useful for the client. 

Regards, 

Alejandro

[SpartaBI · Accepted solution]

@Anonymous are you familiar with dax studio and its view metrics feature?

[Anonymous]

No, but I will investigate in that way if there is the possiblity to know about tables size

[SpartaBI · Accepted solution]

@Anonymous yep, table sizes, column sizes and much much more 🙂 I believe this is what you were looking for 🙂
I'm adding here some good playlists to start from:
https://www.youtube.com/watch?v=gZ4JcqFwJfg&list=PLU6II7MW-aiJ3Z-wbUQ0tkqSbAkyiB3uy

Also, a parralel tool with an excel interface:
https://www.youtube.com/watch?v=p8M7TDiXfxU&list=PLU6II7MW-aiI5A2FjtlVx0yVm3AezOjYr

I will start with DAX studio anyway.

Showcase Report – Contoso By SpartaBI