Extract column sizes

[chriscornell]

Hi everyone, I am trying to retrieve the size of each column in my dataset. While VertiPaq Analyzer in DAX Studio provides me with this information, I have been unable to find a way to extract it into an Excel sheet.

The "Analyze in Excel" option only gives me the values existing in the dataset in a pivot table, which is not what I am interested in.

All I want is to be able to obtain a table of each column in the tables with their corresponding sizes.

Does anyone know how I can achieve this?

[chriscornell]

I haven't thought that it could be this easy. Thanks!

[Fowmy]

@chriscornell 

Glad it works for you, please accept my answser as the accepted solution so it will be useful for others in the community.
Thanks 

[Fowmy · Accepted solution]

@chriscornell 

You can press CTRL + A inside the data grid that you see, and CTRL+C to copy and paste in Excel.