Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Jimmy

 

I am trying to plot about 700 000 rows - are you saying it won't be possible using custom visuals and that if I want to plot such I should use R-Script - however noting that there will be a limitation of 150 000 rows?

 

Kind regards

Rajesh

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi Rajesh_G,

     

    Yes, there's row, column and datasize limitation in power bi, you can find more details in the official documentation. If you have solved your problem, could you mark this answer to finish this case?

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Jimmy

       

      Thank you for your response - could you provide me with a link to the documentation? Also, why are there such low limits? Unfortunately I can't mark anthing as a solution as this problem is still not solved - I've tried making a change to the JSON file but no change is actually implemented even if I just change it from 10000 to 30000.

       

      Kind regards

      Rajesh