Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

R Limitations

I would like to know how i could handle the data export with R    My dataset is more than 10millions line.  I know that one export is limitted to 150k.  So I write the following program to split ...
  • v-ljerr-msft's avatar
    9 years ago

    Hi Anonymous,

    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.


    Considering this limitation which is the limit on all R-scripts at the moment on Power BI Desktop(For example, in your program above, the nrow(dataset) will always return 150000 when the dataset is more than 150,000 rows.), I don't think it is possible to break this limitation currently. :smileyhappy:

     

    Regards