Power BI How to determine which field/table is consuming more space in data model| Data size issue
This is a short video explaining how to determine the field or table size in Power BI. If you are dealing with large data set, you would have come across a situation where data model/pbi size is high. To reduce the size, the first step is to determine which field or table is consuming more space.
This video provides instructions about determining the size of the fields or table.
Script used :
select dimension_name, attribute_name,round(dictionary_size/1024,2) as field_size_kb from
$SYSTEM.DISCOVER_STORAGE_TABLE_COLUMNS
order by dictionary_size desc