This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
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!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.