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
- Fowmy
Super User
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!
- 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
