Forum Discussion

Luukvv93's avatar
Luukvv93
Helper II
7 years ago

Error forecasting with ARIMA visual

Hi,

 

When using the ARIMA visual in Power BI Desktop I encounter the following error. Any thoughts on how to resolve this? 

 

 

7 Replies

  • v-evelk's avatar
    v-evelk
    Microsoft Employee

    Hi,

     

    As I know, Desktop doesn't provide R libraries.

    You shoul install R studio I suppose and install necessery packages there (The error says what packages it looks for).

     

    Kind Regards,

     

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]

    • Luukvv93's avatar
      Luukvv93
      Helper II

      Hi v-evelk ,

       

      I have R installed on my desktop. I also installed the missing XML package so I wonder what goes wrong

      • v-evelk's avatar
        v-evelk
        Microsoft Employee

        Check all the packages in the chain please.

        I see in the message that "htmlwidgets" package is also required.

         

        Kind Regards,

         

        Evgenii Elkin,
        Software Engineer
        Microsoft Power BI Custom Visuals
        [email protected]

  • Dear Luukvv93,

     

    After struggling all morning to fix this too, what I did was the following:

     

    1. Install R-4.1-1 from here:

    https://cran.r-project.org/bin/windows/base/

     

    2. Install R Studio from here:

    https://www.rstudio.com/products/rstudio/download/

     

    3. Install Rtools from here and follow all the instructions:

    https://cran.rstudio.com/bin/windows/Rtools/

     

    4. Install all packages required in the console with the following sentence:

    install.packages("NAMEOFTHEPACKAGE")

     

    4.1 Here is a list of the packages that I installed:

    • htmlwidgets
    • caTools
    • scales
    • reshape2
    • forecast
    • plotly

    5. Open Power BI Desktop, go to File -> Options and Settings -> Options -> R scripting -> Detected R home directories: -> R-4.1.1 -> OK

     

    And that's it! You should be able to see "Forecasting with ARIMA" visual.

     

    I hope it works.