Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Error Message "power bi the query contains a filter with too many values, "

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

2 REPLIES 2
v-juanli-msft
Community Support
Community Support

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

Anonymous
Not applicable

Hi Maggie / 

 

 

 

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors