Can't display this visual - Forecast visual

[gunicotra]

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!

[themistoklis]

@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]

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 · Accepted solution]

@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]

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