Forum Discussion

np212r's avatar
np212r
Regular Visitor
8 years ago

R script: Unable to connect- envsxp

Hi I continue to get "Unable to Connect. Details: ENVSXP" When trying to connect my rscript to powerbi. My script runs completely fine on RStudio but just cannot connect to PowerBI. I see that this error occurs when I try to use a function from the anomalize package. What does ENVSXP mean, and how do I fix this error.

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi np212r,

     

    Please follow this document to check whether you applied correct steps to run R script in Power BI desktop.

     

    Regards,

    Yuliana Gu

     

    • np212r's avatar
      np212r
      Regular Visitor

      Yes, I have. Here is a script you can run and see the ENVSXP error. However, when you run this script in Rstudio it works perfectly.

       

      library(anomalize)

      library(dplyr)

      sub= tidyverse_cran_downloads %>%
        time_decompose(count) %>%
        anomalize(remainder)

    • np212r's avatar
      np212r
      Regular Visitor

      Yes, I have. Here is a script you can run and see the ENVSXP error. However, when you run this script in Rstudio it works perfectly.

       

      library(anomalize)

      library(dplyr)

      sub= tidyverse_cran_downloads %>%
        time_decompose(count) %>%
        anomalize(remainder)