topic 30000 row limit in Developer

30000 row limit

brypie — Tue, 11 Apr 2017 10:23:16 GMT

Hi All,

I'm pretty new to Power BI, but I have been asked by a client to investigate the use of the 3rd party "HierarchySlicer" visualization.

That particular visualization has a built-in data record limit of 4000 (by using the dataReductionAlgorithm code).

I can tweak the number specified in the code to be a larger number, but no matter how high I set it, I am only ever getting back a maximum of 30,000 records.

The client has more than 30,000 records in the data set they wish to show in the slicer.

I also followed a simple tutorial to create a quick slicer visulization of my own, but I'm hitting the exact same 30,000 row limitation.

"dataViewMappings": [
        {
            "categorical": {
                "categories": {
                    "for": {
                        "in": "fields"
                    },
                    "dataReductionAlgorithm": {
                        "top": {
                            "count": 500000
                        }
                    }
                }
            }
        }
    ],

Is this something that can be worked around, or is there an alternative way of getting all the required data to show?

Does the same limitation apply if/when the dashboard is published?

Many thanks, and apologies if this is duplicating queries...

Re: 30000 row limit

deldersveld — Tue, 11 Apr 2017 14:49:55 GMT

That's currently a hard limit for the data reduction algorithm.

30,000 options in one slicer is a lot. Would the client be open to using a combination of Filters and maybe training them on the Basic or Advanced filter criteria?

Re: 30000 row limit

v-chuncz-msft — Wed, 12 Apr 2017 12:17:47 GMT

@brypie,

You may try dataReductionAlgorithm "window" instead of "top".

Re: 30000 row limit

brypie — Mon, 17 Apr 2017 08:32:48 GMT

Thanks,

Yes - the client will implement some form of pre-filtering before using the slicer visual.

Thanks for confirmation of the 30,000 limit.