Forum Discussion

luxpbi's avatar
luxpbi
Helper V
8 years ago

R script visual not working in Service

Hi,    I've created a R visual that load data from RData Files. Everything is working fine in desktop.    But I have problem when I upload it to the cloud, the script doesn't found the path of th...
Need Help
TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

 

okay now it becomes clearer ...

 

Unfortunately there is this data point limit of 150000.

 

If you can't "compress" the number of data points there will be no solution.

 

Once I had been challenged with a similar problem ...

 

Lets assume your dataset looks like this

A | this | 1

A | this | 1

A | that | 2

 

I prepared the dataset that I passed to the R script visual in this way (I collapsed the dataset)

A | this | 1 | 2

A | that | 2 | 1

 

Inside the R script visual I then "expanded" the dataset again. I used the R package data.table for the collapsing and also for the expansion.

 

if you have to "visualize" more than 150000 datapoints at the same time, also considering filtering the dataset / the dataframe by Power BI Slicer and you are not able to collapse the dataset/dataframe that is passed to the R script visual, there is no solution - unfortunately.

 

Regards,

Tom

luxpbi's avatar
luxpbi
Helper V
8 years ago

Hi Tom, 

 

Thank you very much for your answer. 

 

So I think for the moment the only solution in to make it work in Power BI Desktop.

 

Do you know if you can manage permisions in the desktop ? I don't want user to be able to manipulate data for example...

 

Regards.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey luxpbi

     

    I'm jumping over to this thread as I saw you opened a new question specific to getting this working in the service. Tom's idea to collapse and expand is really neat. I also wanted to ask, is your R visual performing any aggregations that you could perform in your data model before importing into the visual? 

     

    Thanks,

    Parker