Forum Discussion
"Too many values." Error, in R visual, but not consistent with display issues
Hi Anonymous ,
As mentioned in document:
Data size limitations – data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image.
This is the limitation on the data "used by" R visual. Even your visual never grow larger than 5*5, it consumes more than 150K rows data to do aggregation and calculation so that it can return your the data in 5*5 chart. So once your put a fields with more than 150K rows, please always apply a filter.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi Anonymous ,
As mentioned in document:
Data size limitations – data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image.
This is the limitation on the data "used by" R visual. Even your visual never grow larger than 5*5, it consumes more than 150K rows data to do aggregation and calculation so that it can return your the data in 5*5 chart. So once your put a fields with more than 150K rows, please always apply a filter.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
This seems like a huge oversight on behalf of PowerBI. Without being able to use more than 150k rows, there should be some kind of random filter to just randomly delete data down to that number.