Forum Discussion
Extract column sizes
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
You can press CTRL + A inside the data grid that you see, and CTRL+C to copy and paste in Excel.
3 Replies
chriscornell
You can press CTRL + A inside the data grid that you see, and CTRL+C to copy and paste in Excel.I haven't thought that it could be this easy. Thanks!
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
