Error in running an R script in Power Query

[ImkeF]

Hi there,

I'm running into a problem with most of my R-scripts, as they simply don't run in Power BI although they run in RStudio.

Simple sample:

library("Quantmod")
getOptionChain("AAPL")

Error-message:

Details: "ADO.NET: R script error.
Loading required package: xts
Loading required package: zoo

Attaching package: 'zoo'

The following objects are masked from 'package:base':

    as.Date, as.Date.numeric

Loading required package: TTR
Error: package or namespace load failed for 'TTR':
 package 'curl' was installed by an R version with different internals; it needs to be reinstalled for use with this R version
Error: package 'TTR' could not be loaded
Execution halted

The error-messages vary slightly from script to script, but are very similar, as they always complain about different internals problems with loading libraries that load fine in RStudio.

Shouldn't this simply work?

I've tried several R-versions between 3.4 and 3.6

Thanks.

[v-yulgu-msft]

Hi @ImkeF ,

Please make sure you have installed required packages successfully, referring to this article.

Best regards,

Yuliana Gu

[ImkeF · Accepted solution]

Hi @v-yulgu-msft ,

this is a bug that others have as well: https://community.powerbi.com/t5/Issues/R-visual-error-quot-package-was-installed-by-an-R-version-wi...

Forgot to close this thread, sorry.