Forum Discussion
R Script Error when viewing report on Powerbi.com
I have created a report where I use one simple R-visual. It's a basic correlation plot and it works perfectly when running in Power BI Desktop.
But when I have published the report and try to view the R-visual online I get R Script Error and the following error message:
Error in if (min(corr) < -1 - .Machine$double.eps || max(corr) > 1 + .Machine$double.eps) { : missing value where TRUE/FALSE needed In addition: Warning message: package 'corrplot' was built under R version 3.2.4
Anyone who knows why this happens or have seen similar issues with their R-visuals?
Thanks,
Magnus
This is actually quite strange... I installed latest version of Microsoft R Open on my machine and was still able to run the visual successfully on my Desktop with same data set.
I then examined the data set a little more and I was aware of that some of the columns contained quite many nulls, I thought that shouldn't matter since I stated to use pairwise observations only in the cor function... But when I replaced all nulls with 0 and uploaded the new version to powerbi.com it actually rendered as it should...
I don't fully understand how the cor function is supposed to handle nulls but in this case it actually makes sense to set null=0 in order to make the data set more logical. And since it then also executes properly i guess I'm happy for now :)
Interesting to here if Microsoft comes back with some comment on your mail, please update this post if you receive some response.
Thanks,
9 Replies
My initial guess would be that you are using a function of corrplot that is not supported in version 3.2.4 of R. corrplot is a supported package per this documentation:
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-r-visuals/
That's a complete guess on my part. You might check that article for any other potential limitations you might be hitting.
The script I'm using is the simplest of all kinds and full code is:
library(corrplot)M<- cor(dataset, use="pairwise.complete.obs")
corrplot(M,method="circle")As you say, corrplot is a supported package according to Microsoft and I find it hard to believe that my use of the function should be of any special difficulty for the R-engine to handle?
You have any sample data? I could try to replicate your issue.
Just as an aside, I assume this works fine in Desktop and in your R IDE?
