Use HighCharter Package/hchart() In Power Bi

[141507]

library(xts)
library("forecast")
library(highcharter)
dates=as.Date(dataset$ReceivedDate,"%Y-%m-%d")
xs=xts(dataset$Volume,dates,frequency=12)
#plot(xs)

arima1 <-arima(xs,order=c(3,0,1),seasonal=list(order=c(0,1,2),period=12))
q=forecast(arima1,h=60,level=c(80,82))
hchart(q)

Hi, 

I am using Highcharter R package for tooltip in the plot.  I am using above code to generate tooltip over the forecast plot. When I use this in R studio, it is plotting well with sufficient tooltips. When I use in power BI, I am getting the message "No image/visuals created". Can you please help us in this regard.

Regards,

Senthil D

[v-huizhn-msft]

Hi @141507,

In Power BI desktop, you need to import your resource data into table from "Get Date" on home page. Then you select the column as value level, please see the fields in blue line. You will find the dataset generates automatically in the black line zone.



Then please type R script in red line zone, click run, you will get the expected result based on R script.

Best Regards,
Angelia

[141507]

Hi Angelia,

I did the same way only, framed necessary data set and sets as value level. The problem I am facing is visual not created. It says "No image/visual created". I am using hchart function to plot the forecast values.

Is anything to I need to change in my code ?

I shared my R code with this topic intially and attached the screenshots for your reference. Please check and provide us possible suggestions. If you need

Regards,

Senthil D

[v-huizhn-msft]

Hi @141507,

When executing a R script that results in an error, the R visual is not plotted and an error message like yours is displayed on the canvas. Do you mind share your .pbix file for further analysis?

Best Regards,
Angelia

[141507]

Hi Angelia,

I could not able to find the option to attach .pbix file in this reply blog. However I attached the code. Please check.

dataset <- data.frame(ReceivedDate,Volume)
dataset <- unique(dataset)

library(xts)
library("forecast")
library("highcharter")
dates=as.Date(dataset$ReceivedDate,"%Y-%m-%d")
xs=xts(dataset$Volume,dates,frequency=12)
#plot(xs)
arima1 <-arima(xs,order=c(3,0,1),seasonal=list(order=c(0,1,2),period=12))
q=forecast(arima1,h=60,level=c(80,82))
hchart(q)

Regards,

Senthil D

[141507]

Hi,

Is any update on my above query.

Regards,

Senthil D

[Anonymous]

Hi @141507 I'm trying to do the same thing as you, plot an interective graph from Rstudio in Power BI. I tried using dygraphs and plotly, but both give me the "Cant display image(...)" message. Did you figure out how to do this? Would you mind sharing? Thank you!

[141507]

Hi, Unfortunately I did not get any solution for this. Hope Power BI Support team will revert.

Regards,

Senthil D