Solved: How to see what is taking up memory/space in Power...

Anonymous · ‎09-19-2018

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?)

v-shex-msft · ‎09-20-2018

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:

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

v-shex-msft · ‎09-20-2018

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:

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Anonymous · ‎09-21-2018

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

Thansk
Raj

Anonymous · ‎09-23-2018

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

v-shex-msft · ‎09-24-2018

Hi @Anonymous,

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

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Anonymous · ‎09-24-2018

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