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,
today appeared several errors on a report, with this message "power bi the query contains a filter with too many values, for queries against the model and server. the maximum number of value allowed in a single filter is 500. Please reduce the number of selected values in the filter"
My doubt is, how to manage this? Shouldn't the filter accept all the range?
And, i need to select the possible 500 values on a attribute filter placed at level or report page?
Seems a little strange having to manage this.
Regards
Hi @Anonymous
Do you use deflaut slicer visual or any other custom slicer visual, like HierarchySlicer?
Do you connect to data source in live connection?
Base on my knowledge, after version 2017/11, Power bi have removed our 500 value limit on how many values you can match when filtering for all data sources except Live connections to analysis services models.
Best Regards
Maggie
Hi Maggie / v-juanli-msft,
I use hierarchy slicer, but the problem doesn't happen there, mas on the slicers, card and matrix that exist it happens, exactly because it's connected to a SSAS Tabular model.
Is there anyway to remove, or at least change the limit? I must place a filter at Report or Page Level ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |