Forum Discussion

gunicotra's avatar
gunicotra
Icon for Helper II rankHelper II
5 years ago
Solved

Can't display this visual - Forecast visual

Hi to everyone,

I am trying to use a forecast visual to predict the future values of a measure, but as son as I droped the "Date" elements in the visual (I didn't even inserted the measure!) I got this result:

 

Error Message:
R script error.
Loading required package: XML
Loading required package: htmlwidgets
Loading required package: zoo
Loading required package: plotly
Loading required package: forecast
Loading required package: lubridate
There were 12 warnings (use warnings() to see them)
Error in plot_ly() %>% layout(title = "", xaxis = ax, yaxis = ay) :
non trovo la funzione "%>%"
Calls: tryCatch ... tryCatchList -> tryCatchOne -> <Anonymous> -> defaultMessage
Esecuzione interrotta

 

Should 

Can anyone give me some hint?

Thanks in advance!

 

  • gunicotra 

     

    the R version that you downloaded is sufficient for your needs but the problem can easily be spotted if you use another software client

    My advice is to run the code in R Studio first

     

    This way you will find out if there are libaries missing and identify the errors.

    From the error message it seems that you need to install a few libraries first

4 Replies

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion

    gunicotra 

     

    This is an R script. Whe nyou run it on another client e.g. R Studio or Anaconda do you get the same error

     

    It seems like there is an error in the R script

    • gunicotra's avatar
      gunicotra
      Icon for Helper II rankHelper II

      Hi themistoklis,

      I think I don't have RStudio or Anaconda... maybe this is the problem? I just downloaded "Download R 4.0.4 for Windows" and updated the PowerBI R-info on File--> Options & settings--> Options --> R-scripting with this :

       

       

       Now I used another Visual: "Forecast using ARIMA" in may report. As soon as I dragged and dropped the measure in the Value item I got this result:

       

      Feedback Type:
      Frown (Error)

      Timestamp:
      2021-03-25T12:18:48.3188117Z

      Local Time:
      2021-03-25T13:18:48.3188117+01:00

      Session ID:
      bf315a3c-a559-45b0-bf56-3340502b2f93

      Release:
      March 2021

      Product Version:
      2.91.701.0 (21.03) (x64)

      Error Message:
      R script error.
      Loading required package: XML
      Warning messages:
      1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
      there is no package called 'XML'
      2: In libraryRequireInstall("XML") :
      *** The package: 'XML' was not installed ***
      Loading required package: htmlwidgets
      Warning messages:
      1: In library(package, lib.loc = lib.loc, character.only = TRUE, logical.return = TRUE, :
      there is no package called 'htmlwidgets'
      2: In libraryRequireInstall("htmlwidgets") :
      *** The package: 'htmlwidgets' was not installed ***
      Loading required package: scales

        

       

      etc.etc.. (it's along errore message I don't want to bother you with the rest of it!).

      • themistoklis's avatar
        themistoklis
        Icon for Community Champion rankCommunity Champion

        gunicotra 

         

        the R version that you downloaded is sufficient for your needs but the problem can easily be spotted if you use another software client

        My advice is to run the code in R Studio first

         

        This way you will find out if there are libaries missing and identify the errors.

        From the error message it seems that you need to install a few libraries first