Using Plot_ly with R in Power BI Desktop

[akj2784]

HI All,

I am trying to use plot_ly with R in Power BI R Visual. The visual works fine  in R studio. But when I run the same code in Power BI Desktop, it does not show chart. 

I am getting the below error.

Is there any installation required to use the same ? As far as I know Power BI supports Plot_ly.

Regards,

Akash 

[Ajithd]

Hi, this is really embarassing to say the least. Last week the solution seems to work. All the R packaged as instructed in the second link worked. However opening Power BI today I got the same error message. I am not sure is it because cran.usr-project.org website blocked by our IT department.

[Ajithd]

I actually sorted this out. I have installed R from this site. https://cran.r-project.org/ (R for windows). This worked.  Probabaly all the above and this final step helped.

[stretcharm · Accepted solution]

I belive that you have to create a custom visual to make use of plotly and htmlwidgets.

Its a bit more work but the results are now more interactive.

https://powerbi.microsoft.com/en-us/blog/interactive-r-custom-visuals-support-is-here/

Check out these blogs on creating your own r visual

http://radacad.com/interactive-map-using-r-and-power-bi-create-custom-visual-part-1

http://radacad.com/interactive-charts-using-r-and-power-bi-create-custom-visual-part-2

http://radacad.com/interactive-charts-using-r-and-power-bi-create-custom-visual-part-3

[Ajithd]

Thanks you. It worked for me too.

[akj2784]

Thank you. I have actually followed the steps mentioned in the 1st blog i.e. part 1.

But somehow after all the installation, I am not able to see my sampleRHTMl in the visual at Pwoer BI Desktop.

[akj2784]

Never mind. Got the answer. 

Thank you for your help.

Regards,

Akash

[Anonymous]

Hi Akash @akj2784 
 
Can you tell me how you have fixed it in the end?
 
I get the same error message and already followed the steps suggested by , but it did not work out. Since you have solved it, it would be great to tell me how !
 
Best

[akj2784]

I actually don't remember what I did to resolve this. 

But I have faced similar issues in other visuals and looks like your code has to output the result as Chart. It does not support printing the result as table or simply printing the dataframe is not supported.