Forum Discussion

gunicotra's avatar
gunicotra
Helper 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 t...
Need Help
  • themistoklis's avatar
    themistoklis
    5 years ago

    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

themistoklis's avatar
themistoklis
Community Champion
5 years ago

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
    Helper II
    5 years ago

    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
      Community Champion
      5 years ago

      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

      • gunicotra's avatar
        gunicotra
        Helper II
        5 years ago

        Hi themistoklis,

        I did it! 🙂 yes it was a couple of libraries missing. Once I have downloaded "Download R 4.0.4 for Windows" and R Studio power bi resolved the informations correctly.

        Thanks