topic Re: ARIMA forecasting in R Script Showcase

ARIMA forecasting

boefraty — Wed, 08 Feb 2017 10:06:53 GMT

ARIMA forecastin will soon be available as R-powered custom visual.

ARIMA modeling is the general class of models for forecasting a time series. ARIMA stands for an Autoregressive Integrated Moving Average and is among the most popular forecasting techniques.

You may find rich set of parameters inside R-code behind the R visual. Both user mode and automatic modes are available.

Re: ARIMA forecasting

lal_prasad — Wed, 08 Feb 2017 12:13:09 GMT

Thanks a lot. I was looking for this code for a long time. Any plans to develop code for multivariate time series like VAR(Vector Auto regression)

Re: ARIMA forecasting

boefraty — Wed, 08 Feb 2017 12:49:20 GMT

I am glad you find it useful (don't forget to click on "kudos").

We have long list of candidates for next-coming R-powered custom visuals. I will add multivariate time-series analysis to the list :)

We also strongly encourage users like you to submit their own R-script showcases here.

Re: ARIMA forecasting

VT2 — Mon, 13 Feb 2017 04:25:00 GMT

I understand that 'Publish to web' is in the pipeline for R visuals - hopefully this can incorporate ARIMA and VAR analysis

Re: ARIMA forecasting

boefraty — Sun, 23 Apr 2017 07:56:30 GMT

Hi VT2,

Publish to web supports R visuals

Re: ARIMA forecasting

avisagie — Mon, 10 Jul 2017 16:07:23 GMT

Hi I am using hte ARIMA forecasting R-powered custom visual. I am not able to export the forecasted values, the export function only exports my histrical data and not the ARIMA forecasted values?

What i am doing wrong?

Andre

Re: ARIMA forecasting

boefraty — Mon, 17 Jul 2017 14:30:06 GMT

Hi avisagie,

You doing nothing wrong. Unfortunatly R-visuals and R-Custom Visuals are not yet supporting customized data export.

You welcome to request this feature in user-voice
https://ideas.powerbi.com/forums/265200-power-bi-ideas

Re: ARIMA forecasting

141507 — Sun, 30 Jul 2017 17:12:49 GMT

Hi, I am using ARIMA forecasting custom visual, While mid of my development, I am facing the error "Plotly is not defined" (java script error) unfortunately.

It was showing the trend perfectly. But I am facing this issue past couple of days. Can any one help me out.

I have downloaded the necessary packages of R and I am developing ARIMA custom visual in offline. Is this requires internet connection ?

Regards,

Senthil D

Re: ARIMA forecasting

boefraty — Mon, 31 Jul 2017 10:02:22 GMT

Hi 141507,

I never had javascript errors with plotly .
I'd recommend you to remove all R packages and install them from the beginning, you can try installing them from RStudio rather than from PBI desktop. Try using another R-engine (for example 3.3.x and 3.4..x). As well, update the Power BI desktop to the most recent one. Hope it helps.

Re: ARIMA forecasting

141507 — Mon, 31 Jul 2017 15:00:44 GMT

Hi boefraty,

Thanks for your suggestion, I will do the same by installing R 3.4.1 and latest power BI. I have one clarification whether this custom visual of ARIMA forecasting requires online for all time ?

Regards,

Senthil D

Re: ARIMA forecasting

141507 — Tue, 08 Aug 2017 11:04:19 GMT

Hi Team,

I tried the same and could not succeed. I am working in VDI (offline). Is this reason why I am not seeing ARIMA custom visual ? Is this requires internet connection. However I installed necessary packages. Still It is not working in my VDI whereas it is working in my local which is having internet.

Can you please help me out on this.

Regards,

Senthil D

Re: ARIMA forecasting

boefraty — Tue, 08 Aug 2017 11:15:35 GMT

Hi 141507,

In general internet connection is not required.

Make sure you have the last vesrion of the Power BI desktop. Do you have totaly blank visual or failed visual ?

Are we talking about R-visual or R-custom visual?

Re: ARIMA forecasting

141507 — Tue, 08 Aug 2017 11:29:24 GMT

Hi boefraty,

We are talking about custom visual. I am using latest version of power BI and R version 3.4.1

It is an ARIMA forecasting visual (built in R). I tried this visual and it was displayed as expected. But suddenly it is not appearing and visual is failed. It is showing following error message.

Thank you,

Senthil D

Re: ARIMA forecasting

141507 — Wed, 16 Aug 2017 10:27:55 GMT

Hi Team,

Is any update on this.. Any help on this would really appreciable.

Regards,

Senthil D

Re: ARIMA forecasting

boefraty — Wed, 16 Aug 2017 11:54:39 GMT

Hi 141507

It says "plotly is not defined"

Try to clean all R packages previously installed in

c:\Users\username\AppData\Local\Radio\Library\

and

c:\Users\username\Documents\R\win-library\3.4\*

Try to clean-install "plotly" from RStudio consol line.

>install.packages("plotly")

Re: ARIMA forecasting

141507 — Wed, 16 Aug 2017 12:30:28 GMT

Hi boefraty,

I tried the same and getting the attached error. When I open this URL in browser, it is downloading successfully. When try to install from R console, I am getting error

Regards,

Senthil D

Re: ARIMA forecasting

141507 — Wed, 23 Aug 2017 14:34:49 GMT

Hi, I cleared all packages and reinstalled R packages including plotly. Installed the latest power BI version. Still I could not able to plot using Arima R forecasting custom visual. I am not sure where am wrong. It is repeatedly saying "plotly is not defined"

Regards,

Senthil D

Re: ARIMA forecasting

boefraty — Mon, 28 Aug 2017 14:13:15 GMT

Hi 141507,

I am sorry for bad experience you have with this visual.
Are you able to install "plotly" from RStudio or any R Console + to run any simple example ? I mean without Power BI.
If not you should resolve it first.

Re: ARIMA forecasting

141507 — Mon, 28 Aug 2017 14:37:11 GMT

Hi boefraty,

Thanks for your reponse. I managed to have plotly package in R studio. I installed plotly through R studio only and it is displaying samples properly.

Can you please clarify the below:

i) Is the Arima custom visual only work on R engine R 3.3.1 ? (I am having R 3.4.1)

Regards,

Senthil D

Re: ARIMA forecasting

Anonymous — Wed, 01 Aug 2018 20:03:58 GMT

Feedback Type:
Frown (Error)

Timestamp:
2018-08-01T20:03:12.2912593Z

Local Time:
2018-08-01T16:03:12.2912593-04:00

Session ID:
d8b9e5b7-2145-408b-9307-d823cf1a7662

Release:
July 2018

Product Version:
2.60.5169.4101 (18.07) (x64)

Error Message:
R script error.
Loading required package: scales
Loading required package: forecast
Loading required package: zoo

Attaching package: 'zoo'

The following objects are masked from 'package:base':

as.Date, as.Date.numeric

Error in plot.forecast(prediction, lwd = pointCex, col = alpha(pointsCol, :
could not find function "plot.forecast"
Execution halted

OS Version:
Microsoft Windows NT 10.0.17134.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461808]

Peak Virtual Memory:
37.8 GB

Private Memory:
274 MB

Peak Working Set:
372 MB

IE Version:
11.112.17134.0

User ID:
ab317fd6-b857-472d-9fcc-eded5eaf4762

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\winnocenti\Microsoft\Power BI Desktop Store App\FrownSnapShot668302347.zip

Performance Trace Logs:
C:\Users\winnocenti\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_newFromWeb
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_qnaExplore
PBI_variationUIChange
PBI_canvasTooltips
PBI_showIncrementalRefreshPolicy
PBI_compositeModels
PBI_DB2DQ

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

shared births_new = let
Source = Csv.Document(File.Contents("C:\Users\t-jacobm\Documents\births_new.csv"),[Delimiter=",", Columns=3, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Country/Region", type text}, {"Calendar Month", type date}, {"Births", type number}})
in
#"Changed Type";

Getting this as an error when try to look at visual. Any help?