Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community
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
Dominique
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.