Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
I am facing an issue with R integration: Is there a limit to the number of rows that I can feed into R? I want to run an analysis over a very long table and it seems that half of the data is not imported into R. Is that possible?
Regards,
a
Solved! Go to Solution.
Hi @anne,
Currently, R visuals in Power BI Desktop has a few limitations:
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.
For more details about these limitations, you can refer to this article.
Regards
This doesn't answer the question here. The question asked was:
"Is there a limit to the number of rows that I can feed into R?"
But the response is how many rows an R visual can plot. These are NOT the same thing.
Is the limit the number of rows I can feed into R, or the number of rows I can plot? If I bring in 500k rows, summarize them in R, and then try to plot less than 150k rows, will I hit a limit?
Hi @anne,
Currently, R visuals in Power BI Desktop has a few limitations:
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.
For more details about these limitations, you can refer to this article.
Regards
Thanks for the hint!