Forum Discussion
R Script Error when viewing report on Powerbi.com
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,
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?
Thanks, it would be great to see if it works for you.
You can find some sample data here csv file
The fields that I use to calculate the correlation is: ActualPrice.2, Fee.1, LandArea.1, Rooms, Size.1 and SupplArea.1
And yes, it works fine when I run this in Power BI Desktop
Well, I replicated it, but in the Desktop!!
I should note however that I am using Microsoft's MRO Rgui 3.2.3 64-bit as my R runtime. I am betting that you are using something else and I am further betting that whatever Power BI is running is probably more along the lines of what I am running versus what you are running.