find query data sizes

[Anonymous]

Hi's

I have been given a large PBIX file to cleanup/improve. There are some 40-50 queries in it. I am suspecting that data in one or more queries, is the reason for its large size - there are no vicious(!) jpg's in the PBIX file that are causing it to take up space. Once I know the culprit, I try to come up with some filers etc in PowerQuery/M, and then only publish it.

So, I want to find out which all queries are taking up most room. Is there a way I can see the size or sort the queries by their size?

[edhans · Accepted solution]

You can see the sizes of the tables that are actually loaded. This won't show you any "connection only" queries.

See this article. You need to install DAX Studio.

[sdsfive]

Hello - I also need to see the query sizes. I downloaded DAX studio, but I don't see where I can see the query sizes. Can you provide guidance?

[edhans]

It is in the link provided above.