Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

find query data sizes

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?

 

Need Help
  • edhans's avatar
    edhans
    7 years ago

    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.

3 Replies

  • edhans's avatar
    edhans
    Community Champion
    7 years ago

    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's avatar
      sdsfive
      Frequent Visitor
      6 years ago

      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's avatar
        edhans
        Community Champion
        6 years ago

        It is in the link provided above.