Correlation Plot
Hello!
I'm new to R visuals in Power BI. But I've installed Microsoft R Open 3.5.1 and the visual in the example. But when I insert values the visual gives ni this error:
Error Message:
R script error.
Loading required package: corrplot
Warning messages:
1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
there is no package called 'corrplot'
2: In libraryRequireInstall("corrplot") :
*** The package: 'corrplot' was not installed ***
Error in corrplot(M, method = method, order = order, type = type, addrect = addrect, :
could not find function "corrplot"
Execution halted
What am I missing here?
Hi Katalo,
I m really sorry, I am also a beginner in Power BI.
Hope you will find the solution.
Regards,
Jaouad
Hi JaouadZrhibi and Katalo,
Run
install.packages("corrplot")from any R console. You can also download script provided with sample
https://community.powerbi.com/oxcrx34285/attachments/oxcrx34285/RVisuals/12/16/ScriptInstallPackagesWithWorkaroundsCorrplot.RUnfortunatly, if you use R Visual, power BI can not handle automatic package install.
In case of R Custom Visual
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380814?tab=OverviewIt is installed automatically
The local installation of your R will need to include the "corrplot" package. as boefraty stated below you can use the following code to install it.
install.packages("corrplot")You should run that in your local installation of R.
Follow this tutorial to help you install thie package "corrplot"
https://powerbi.tips/2016/09/using-r-visuals-in-power-bi/
Kataloprobably you figured it out by now. If not, I am not sure if the following steps solve your problem but this is my two cents. Initially, I faced a lot of trouble with R (got the similar message as you did). After a long trial and error and knocking on many doors I solved it by using the following
When I run R in PBI, the packages are accessed by PBI from C:\Users\xxxx\Library.
However, when I install the packages from R studio, the installed packages get saved in C:\Users\xxxx\Documents\R\win-library\3.5.
After installing a package, I copy that package
from
C:\Users\xxxx\Documents\R\win-library\3.5
to
C:\Users\xxxx\Library
Everything seems to work fine after that.
