How to see what is taking up memory/space in PowerBI desktop file

[Anonymous]

Hi all,

Is there a way to see what is taking up memory/space in a PowerBI desktop file?

Eg Table_A is 38mb and Table_B is 45mb (and even if you could break it down to a column level?)

[Anonymous · Accepted solution]

Hi @Anonymous,

I'd like to suggest you use SSMS to connect to power bi data model and run t-sql query to check tables size.

Reference links:

Connect to Power BI Desktop Model from Excel and SSMS

Get size of all tables in database

Regards,

Xiaoxin Sheng

[Anonymous]

Good info, Thanks.Is there anyway to do this memory consumption analysis within Power BI itself without connecting to SSMS?

Thansk
Raj

[Anonymous]

Agreed - and if not, I'll likely raise a suggestion 

[Anonymous]

Hi @Anonymous,

Nope, power bi itself not contains these features, you need to use third party memory analytics application.

Regards,

Xiaoxin Sheng

[Anonymous]

Thank you @Anonymous