"Too many values." Error, in R visual, but not consistent with display issues

[Anonymous]

I have a barchart R Visual in PowerBI. I have all the same groups for three different years, so the exact same x axis for each year and the same number of bars. But if I try displaying the data from all years, I get the error of "Too many values." But if I select any combination of two of the three years, it works, which is really confusing to me. So the size doesn't change, only the bars, which show averages, changes slightly. But why are there too many datapoints?

If I try to manually reduce datapoints in the R Visual (through R code), it still gives the same error. Any ideas?

[Anonymous · Accepted solution]

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

[Anonymous]

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.