Forum Discussion
Memory Usage spikes when adding dimension column to table visual
- Anonymous4 years ago
The problem was four columns which were basically place-holders. Three columns should have headers but no entries (blank) and one column should have a header but all entries should say FALSE. In order to do that, I created three blank measures and one false measure. When I add a single blank measure as a column, then the visual shows no rows anymore. However, when I add the false measure as a column then it shows all rows again. Pretty strange behaviour as far as I can see. Would be nice to be able to create measures rather than calculated columns for this purpose but the loading times are just too long. Without the blanks and false column the visual loads in no time just as expected.
Thanks for the suppoert lbendlin
I assume this is Direct Query? Potentially in a Mixed mode with other datasets as source? Have a look at your query log... you may find that your mixed mode creates monster queries because your key columns linking the data model have high cardinality.