R script visual not working in Service

Question

Hi,&nbsp;&nbsp;I've created a R visual that load data from RData Files.&nbsp;Everything is working fine in desktop.&nbsp;&nbsp;But I have problem when I upload it to the cloud, the script doesn't found the path of the files because they are in local ... obiously.&nbsp;How can I solve this?&nbsp;Thanks in advance!

tommartens · Answer

Hey,&nbsp;okay now it becomes clearer ...&nbsp;Unfortunately there is this data point limit of 150000.&nbsp;If you can't "compress" the number of data points there will be no solution.&nbsp;Once I had been challenged with a similar problem ...&nbsp;Lets assume your dataset looks like thisA | this | 1A | this | 1A | that | 2&nbsp;I prepared the dataset that I passed to the R script visual in this way (I collapsed the dataset)A | this | 1 | 2A | that | 2 | 1&nbsp;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.&nbsp;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.&nbsp;Regards,Tom

stachu · Answer

I think you need data gateway so the service can get access to your local fileshttps://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-local-drive

luxpbi · Answer

Hi&nbsp;Stachu,&nbsp;The problem is just with the visual.&nbsp;I attach photos in case it helps to see the problem.

tommartens · Answer

Hey,&nbsp;as far as I understand your R script that works perfectly in your Power BI Desktop contains basically these 3 steps:read source dataprepare the datacreate the visualthese 3 steps in one single r script will wonk in PBI Desktop.&nbsp;But this will not work in the service, the reason is:R script visuals or Custom Visuals (R based) are running in a kind of sandbox and are not allowed to access "external" ressources.&nbsp;For this reason you have to split your R scipt.reading the source data (this can be done by using the R script source connection)this step has to return a table object to the Power BI data modelbe aware that it is necessary to install the on-premises data gateway in personal modecreate the r visualbased on the Power BI tableThe data preparation (if necessary) can either be done in the first step or also in the r script that creates the visual&nbsp;This link will maybe also useful:https://docs.microsoft.com/en-us/power-bi/desktop-r-in-query-editor&nbsp;Regards,Tom&nbsp;

luxpbi · Answer

Hi&nbsp;TomMartens,&nbsp;First of all, thank you for your answer.&nbsp;&nbsp;If&nbsp;I put the data in my Power BI model with an R script as data source, I have a limitation in the R visual script of 150.000 rows of data isn't it?The fact that my data is out of Power BI and I it's in my R script is to avoid that limitation.That's the way my R script works.&nbsp;Load data&nbsp;Prepare data&nbsp;Pass parameters with Power BI (the idea is that the script will change with the inputs of the users)Create the visualAs I said in Power BI Desktop everything is working fine. The problem ocurs in the service, I understand the sandbox you are talking about, but is the a way to solve my situation?&nbsp;Thanks again.&nbsp;Regards.

Forum Discussion

R script visual not working in Service

7 Replies

Related content

R Script Visuals Stopped Working

Temp table not working in Pipeline Script activities

Embedded Report Fails to Load (Works in Service); Token Generated via Script

Gallery Terms of Service

R script not working in Service