Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Table size - performance

My PBI model contains a table of 8 rows and 14 columns, 10 integers, 4 text (7 char); 112 data items. According to DAX Studio it’s easily the largest object in the model at over 2Mb, taking up over “...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    The SQLBI link is helpful. Evaluating the Year table takes only a couple of milliseconds so I guess I don't have to worry about it even if its size is still a mystery.

    Thanks for your input, davehus .

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
4 years ago

Hi Anonymous , The server timings in Dax Studio wil give you an idea of the sql code being run on the query. In terms of the improving performance, are you in a position to apply this if statements upstream in powerquery?

 

Did I help you today? Please accept my solution and hit the Kudos button.