Skip to main content

    Power BI

    New

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

    Vote (16) Share
    's profile image

    on 18 Nov 2016 17:34:10

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

    Comments (3)
    's profile image Profile Picture

    b12c5cf7 c5e8-ea11-a817-000d3a9b112e 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

    1d3c2816 59a0-4a15-bb9b-f93ecdd60d0b 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

    86ad44cd 71e9-4117-b85a-cd1da6840582 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