Skip to main content

Power BI

Needs Votes

Increase the limit (1000) of values for filtering in Query editor

Vote (21) Share
's profile image

on 18 Nov 2016 17:34:10

Increase the limit (1000) of values for filtering in Query editor

Comments (4)
's profile image Profile Picture

AbdelRahman Seyam on 08 Mar 2021 19:00:07

RE: Increase the limit (1000) of values for filtering in Query editor

I need to expand columns with more than 1000 rows of data.

's profile image Profile Picture

Lanqing Brownell on 28 Aug 2020 00:34:58

RE: Increase the limit (1000) of values for filtering in Query editor

When we connect to a COSMOS DB, the limit leads to the transform window not able to list all the columns before loading the data.
Is there a way to expand the scan scope by 1000 everytime until the columns I need are all listed?

's profile image Profile Picture

Jeroen Brink on 06 Jul 2020 00:03:05

RE: Increase the limit (1000) of values for filtering in Query editor

We would love this as well. We have an OData feed with 1000+ additional data columns, that are not shown in the MoreColumns query editor. See https://community.powerbi.com/t5/Issues/Power-BI-Desktop-MoreColumns-not-showing-all-columns/idi-p/840975 for our findings.

's profile image Profile Picture

Frank on 05 Jul 2020 23:58:34

RE: Increase the limit (1000) of values for filtering in Query editor

i would love the ability to reduce it, but am voting here because i imagine the implementation will be the same