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 .
davehus
Memorable Member
Memorable MemberHi Anonymous ,
Have a look at this link. https://www.youtube.com/watch?v=V_AHYAFuFs8&ab_channel=SQLBI
Basically the server timings will show what part of the query is the biggest, how long it took to run etc. The size usually relates to how unique the data is your in model. This might help you narrow down why your query is so large.
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 .