Forum Discussion
30000 row limit
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...
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?
3 Replies
- deldersveldResident Rockstar
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?
- brypieRegular Visitor
Thanks,
Yes - the client will implement some form of pre-filtering before using the slicer visual.
Thanks for confirmation of the 30,000 limit.
- v-chuncz-msftCommunity Support