I'm trying to execute the following code on a w7/ 32-bit install of Power BI.
columns#(lf)wbcd_n <- as.data.frame (lapply(dataset[2:31], normalize))#(lf)#(lf)# 'Split for Training & Testing#(lf)wbcd_train <- wbcd_n[1:469, ]#(lf)wbcd_test <- wbcd_n[470:569, ]#(lf)#(lf)# 'assign labels#(lf)wbcd_train_labels <- dataset[1:469, 1]#(lf)wbcd_test_labels <- dataset[470:569, 1]#(lf)#(lf)library(""class"")#(lf)wbcd_test_pred <- knn (train = wbcd_train, test = wbcd_test, cl = wbcd_train_labels, k = 21)#(lf)output <- wbcd_test#(lf)output$result <- wbcd_test_pred",[dataset=#"Replaced Value1"])
DataSource.MissingClientLibrary: ADO.NET: Unable to find the requested .Net Framework Data Provider. It may not be installed.
My R package installation started with local/manual installs until I did the following:
and then step through the code (by pressing enter many times) when R starts debugging during the installation.
The cmd line for R works, but not within R.
My home 64-bit /w10 installation executes the R script.
I'd like to suggest you open the options to check/modify the location setting if power bi can't find the libraries.
In addition, I'm not so sure if the issue is caused with compatibility of 32bit and 64bit libraries.
The R path is viewable in the R script Options :
64/32 bit: I was stating that I have tried to execute R on two different systems/ platforms with different installation approaches because one may be limited by the network security & require local install of the packages. While I was able to install CRAN & RStudio behind the network of the windows 7/32 bit, I had to use
install.packages("packageName") to step through the package installation before I could use R Console. But I can't identify what causing the issue between Power BI & R.
But I don't have this issue on my own machine where Power BI is using the R script from Visual Studio 17 where the framework & packages aren't having issues connecting with Power BI.
Current I can't reproduce this on my device, so it is hard to to find out an effective solution to direct work through your issue.
For your situation, you can try submit a support ticket for further support.
Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.
Click here to read more about the March 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.