cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
luxpbi
Helper V
Helper V

R visual data limitations

Hi, 

 

I'm testing to run an R script visual with Power BI. Everything is working fine, but I have a big doubt.

I know that there is a limitation of 150.000 rows per visual, but, what that really means?

The script loads data from .RData files, not from Power BI. I know that some of you will tell me that why I don't just use RStudio, but believe me that it as to be like that.

In my visual my dataset is composed only by measures with 

 

SELECTEDVALUE()

So the script is recalculated depending on the inputs of the user. 

So, my question is: 

The limitation is going to be a problem because it also afects the .RData files inside my script or no?

 

I tried to explain it as easy as I could, I hope you understood me.

 

Thanks in advance !

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hey @luxpbi

 

I just tested and the 150,000 row limitation only limits the number of rows you pass into the R visual through the "Values" well of the visual itself. I just read a csv of 300,000 rows and the R visual is able to consume all of the rows. So if I'm understanding correctly and you are connecting to data through your R visual, you will not have a limitation on the number of records consumed.

 

Hope this helps,

Parker

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hey @luxpbi

 

I just tested and the 150,000 row limitation only limits the number of rows you pass into the R visual through the "Values" well of the visual itself. I just read a csv of 300,000 rows and the R visual is able to consume all of the rows. So if I'm understanding correctly and you are connecting to data through your R visual, you will not have a limitation on the number of records consumed.

 

Hope this helps,

Parker

Everything is working fine in desktop. 

 

But I have problem when I upload it to the cloud, the script doen't found the path of the files because they are in local ... obiously. 

How can I solve this?

Hi @Anonymous,

 

That's just what I needed, I'm going to do the same test you did and if it works i'll accept your answer as accepted. 

 

Thank you very much for your prompt response. 

 

Regards.

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors