Forum Discussion
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 “...
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 .
Thanks for your reply davehus . Apologies, I don't quite understand what you are asking. My question was really about the table size.
The PBI report does have some performance issues but I don't know if they are related to this inflated table. I'm not sure how to use DAX Studio to do what you are suggesting. Generating the calculated column is reported as taking 2ms in the Formula Engine. But I don't know where to look for knock-on effects, if that's what you mean.