Dynamic R Forecasting Data

[rohuyn]

Hi everyone,

I was able to get my Forecasting in R to work correctly, and can now dynamically update it using slicers. What I cannot do, however, is explicitly see what my forecasted values and its confidence intervals in Power BI. 

I know that I'm able to run a script to get the forecasted data as a dataset, but is there a way to dynamically see that forecast data in a table of sorts the same way that my forecasting visual works?

Appreciate any and all guidance/expertise!

Best,

Ronnie

[ankitpatira]

@rohuyn I don't think you will be able to see that in the data view in power bi itself but how about at the end of your R script use write.csv method that outputs dataset to csv. Try that out, I have never had done this before though.

write.csv(yourDataFrame, file = "C:/MyData.csv")

[rohuyn]

Appreciate the response, ankitpatira! Unfortunately, while your solution is passable for myself, it wouldn't be utilized well upon scale in my organization.

With that being said, I'm curious if anyone else has outputted this data onto Power BI in any other format, or if the R Dev Team has considered adding this functionality.