I have a data table out of which there is a column carring huge data - this data doesn't change per session as in, once provided to visual it is not needed anymore. it may change for different users and different reports but not during the session.
Our observations for a data set,
1. Provide this column to visual's one of the legend and keept it - the update function for any change takes 1.5 - 2 mins (roughly it has 75k rows)
2. Provide this column to visual's one of the legend and after the data loaded in visual, removed the colunm from legend manually - the update funtion for any change takes 5-6 seconds only.
What we're doing with the data in the visual?
We read the data for the first time and cache it in visual memory. And there after we don't at all refer to the data coming in update function parameter for this specific column.
Is there any way we just detach the colum from legend after it is loaded for the first time in visual..?
We're not sure why the there such a huge difference in performance, is this gap really due to the fact that power bi just carries this much data on every update call? is ther any way we can stop this.?
