Executing R Script-Power BI: DataSource.MissingClientLibrary: ADO.NET: Unable to find the requested

[ackrite55]

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.
Details:
    DataSourceKind=R
    DataSourcePath=R

My R package installation started with local/manual installs until I did the following:

debug(utils:::unpackPkgZip)

install.packages("packageName")

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.

[v-shex-msft]

Hi @ackrite55,

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.

Regards,

Xiaoxin Sheng

[ackrite55]

The R path is viewable in the R script Options :

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

debug(utils:::unpackPkgZip)

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.

[v-shex-msft]

HI @ackrite55,

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.

Regards,

Xiaoxin Sheng

[ackrite55]

This is how it appears when attempting to execute the code.

[v-shex-msft]

Hi @ackrite55,

Perhaps you can try to load local script and execute in power query:

Invoke Function writtein in R

Regards,

Xiaoxin Sheng