Forum Discussion
Increasing the row limit on custom visuals
Hi Everyone
How does one increase the row limit on a custom visual which I think is currently a standard of 10000? Also, what is the maximum amount of rows possible?
Kind regards
Rajesh
6 Replies
Hi Rajesh_G,
It depends on the dataReductionAlgorithm session in capabilities.json, you can modify the size which can be exposed to visual in power bi desktop. For more details, please refer to: https://github.com/Microsoft/PowerBI-visuals/issues/44.
Regards,
Jimmy Tao
Hi Jimmy
Thank you for the advise, I have tried that but when I click save on the capabilities.json file and close it and then open the Power BI file with the custom visual, nothing changes. Even if I delete the custom visual and re-import it, theres nothing different. Could you advise me further? Is there perhaps something wrong with my version of Power BI? Or even the way the Custom visual was coded?
Thanks
Rajesh
Hi Rajesh_G,
How many rows do you show in a custom visual? Currently, the maximun limit is 30000 rows, please refer to: https://github.com/Microsoft/PowerBI-visuals/issues/209. In addtion, if you are using custom visual, you can modify the 'count' value to any integer value up to 30000. R-based custom visuals can support up to 150000 rows. Please refer to: https://github.com/Microsoft/PowerBI-visuals/blob/master/Capabilities/DataViewMappings.md#data-reduction-algorithm.
Regards,
Jimmy Tao
