We've got many reports based on SSAS multidimensional incl. a huge dimension and this dimension is used within a filter. Now we're getting an error when we want to select all elements (which works fine) and then we deselect one or more elements. This causes the following error:
The query contains a filter with too many values. For queries against this model and server, the maximum number of values allowed in a single filter is 500. Please reduce the number of selected values in the filter.
The problem occures on-prem and online, the issue seems to be new...
Product Version: 2.59.5135.601 (PBIDesktop) (x64)
Release: June 2018
Any ideas / solutions?
Thank you and best regards