Help! DataSource.Error: ADO.NET: R script error.

[Regiso]

Hello, I am copying a video from @Bielite Importing Stock Data into Power BI 

I am using R 4.0.0 and RStudio 1.3.959.

Rtools, httr, rvest, xml2, BatchGetSymbols are all successfully installed

Here is my script (exactly like the video)

library(BatchGetSymbols)
df <- GetSP500Stocks()

tickers <- df$Tickers

result <- BatchGetSymbols(tickers, first.date = Sys.Date()-365,
last.date = Sys.Date())
result <- as.data.frame(result$df.tickers)

Here is the error message:

DataSource.Error: ADO.NET: R script error.
Loading required package: rvest
Loading required package: xml2
Error: package or namespace load failed for 'rvest':
package 'httr' was installed before R 4.0.0: please re-install it
Error: package 'rvest' could not be loaded
Execution halted

Details:
DataSourceKind=R

I have already reinstalled httr & rvest & xml2 and still get this message.

can you help me get rid of this error?

Thank you!!

[Chitemerere]

Thank you very much for this post. I encountered this error today.  However I still have problems when trying to implement this.  Kindly advise format in the [i] above as I get an error message on this.  Should the address be enclosed in quotes?

Regards,

Chris

[StatsChick]

I keep seening this answer for this issue; however, it does not work for me. I get the same error. Anyone make it work?

[Regiso · Accepted solution]

The problem lies in the path that Power BI follows to get the packages.

1. Go to your R IDE and find out where R goes by typing .libPaths().

2. Then, go to Power BI > Transform > R Script and see where Power BI is going

3. Make it a df <- as.data.frame(.libPaths())

4. See if Power BI has the same list you do. 

5. Add this one line to the top of your R script in Power BI  .libPaths(.libPaths()[i]) where i is the line with the address that matches your R IDE

6. Voila!

All credit for this solution goes to Stacia Varga at Plural Sight - read the blog here: Data Inspirations Solves the Power BI R path issue 

@_StaciaV_