Forum Discussion
Post PartisanUsing Plot_ly with R in Power BI Desktop
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
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
8 Replies
- stretcharm
Memorable Member
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
akj2784Thank 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
AjithdHelper I
Thanks you. It worked for me too.
- 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.