Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Timohven
Regular Visitor

interactive R graphics libraries does not work in PBI

I tried using dygraph and plotly , but they give me any error or graph.

I used this: https://radacad.com/interactive-map-using-r-and-power-bi-create-custom-visual-part-1

If the chart is made non-interactive, then everything works.

Screenshot 2023-03-24 202728.png

Help me please!

5 REPLIES 5
lbendlin
Super User
Super User

what's the error message?  Are you trying to plot to a non-standard output device?

I want to plot a simple interactive graph in power BI only.

I use:

rhtml template 

"pbiviz package" does not throw errors

in power BI I have no errors, but and the graph is not visible too

 

 

source('./r_files/flatten_HTML.r')

############### Library Declarations ###############
libraryRequireInstall("ggplot2");
libraryRequireInstall("plotly")
####################################################

################### Actual code ####################
qplot(`Petal.Length`, data = iris, fill = `Species`, main = Sys.time());
g = qplot(`Petal.Length`, data = iris, fill = `Species`, main = Sys.time());
####################################################

############# Create and save widget ###############
p = ggplotly(g);
internalSaveWidget(p, 'out.html');
####################################################

# ################ Reduce paddings ###################
ReadFullFileReplaceString('out.html', 'out.html', ',"padding":[0-9]*,', ',"padding":0,')
####################################################

You must plot to the default device

 

Create Power BI visuals using R - Power BI | Microsoft Learn

How can i do this? I just used the template example. It says in the reviews that it works without any changes. Thanks a lot

How can I do this? I just used the  "rhtml" template. It says in the reviews that it works without any changes. Thanks a lot

That would be a question for whoever wrote the reviews.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.