I have a problem with a published dataset, with the error message "Looking up invalid data on a dense spool". It happens with a single measure and only in PBI Service. The dataset was fine and thi...
Hello all,
I have the same issue.
I noticed that the RLS changes the number of visuals which cannot be displayed due to this error.
When the RLS is on, I cannot see 7-9 visuals due to this error but when RLS is off only 2 visuals are not visible.
Then when I removed the filters applied to those 2 visuals via the Filter pane the error is gone.
So for my report, it seems that the problem comes from the filter context generated outside the measure (RLS / filter pane).