Forum Discussion
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-evelkMicrosoft 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]- v-evelkMicrosoft 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]
- SamsonAnalyticsFrequent Visitor
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.