cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

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

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.

5 REPLIES 5
Community Support
Community Support

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.

9.PNG

In addition, I'm not so sure if the issue is caused with compatibility of 32bit and 64bit libraries.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

The R path is viewable in the R script Options :

 

R Script OptionsR 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.

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Rerror.png

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

Hi @ackrite55,

 

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

Invoke Function writtein in R

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors