Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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...
Solved! Go to Solution.
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?
You may try dataReductionAlgorithm "window" instead of "top".
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?
Thanks,
Yes - the client will implement some form of pre-filtering before using the slicer visual.
Thanks for confirmation of the 30,000 limit.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 |