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
Anonymous
Not applicable

R visual

Hi there

 

According to the link below, network3D is supported on powerbi desktop / service.

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-r-packages-support/

 

so I loaded the data as in using R Script through Get Data in powerbi desktop

 

# Create fake data
src <- c("A", "A", "A", "A",
        "B", "B", "C", "C", "D")
target <- c("B", "C", "D", "J",
            "E", "F", "G", "H", "I")
networkData <- data.frame(src, target)

 

Then on a new page, I use R Script visualisation and select target and src from my table

 

then put R script in

 

library(networkD3)

simpleNetwork(dataset)

 

I received a message No image was created. The R code didnt result in creation in any visuals....

 

where did I go wrong?

Many thanks

 

Pedzilla

10 REPLIES 10
jfreyha
Frequent Visitor

any updates on this topic? Im having the same problem

ZachZ
Regular Visitor

I am running into same issue a @Anonymous. It seems Simplemnetwork function of NetworkD3 package generates an html file which seems not supported in PowerBI.

 

If someone could give an idea on how to use NetworkD3 to generate graphs in Powerbi Desktop i would be very thankful

vanessafvg
Super User
Super User

@Anonymous i think you have download the r visuals you cant load them in the same way you do it in r

 

https://store.office.com/search.aspx?productgroup=PowerBI&qu=r%20visuals

 

unless i misunderstand you?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Anonymous
Not applicable

Hi there

Thats the bit that I am confused.

It is not a custom visual - its an R script called Network3D which I apply to visualise my dashboard but it doesnt seem to work however according to the link it is supported.

 

Unless the article refers to the developers who want to develop R custom visuals?

 

@Anonymous its not a custom visual in R, but its a custom visual in Power BI.  can you not download it from the store?  what i am saying have you downloaded the visual you need from the store?  

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Anonymous
Not applicable

Hi there

 

so this paragraph of the article mentions:

 

For Power BI Desktop has two variations for R packages:

  • For R visuals, you can install any package, including custom R packages
  • For Custom R visuals, only public CRAN packages are supported for auto-installation of the packages

So I have the right package installed (as i could run the sample successfully in RStudio)

However when i do this in desktop i got the error message.

 

There is no R custom visual Network3D to download from office store.

 

I downloaded other R custom visuals in the past and it worked fine e.g corrplot, decision tree fancyplot etc...

 

I just wonder if I have to develop Network3D of my own and import it as custom visual for this to work?

 

Hope this makes sense?


Many thanks

Hi @Anonymous,

After research, Network3D is R package. You want to create R visual using the sample given. There are two methods.

1. You should create a resource table in Power BI desktop as follows。

1.PNG

Then you add a R visual, select src and target columns as values, it will generates the dataframe automatically, and you can not change it. Type the R script in the zone highlighted in green line, and click run. You will get expected result.

2.PNG

2. You can run r scrip in R visual, and get the data from R scrip, more details in this blog. Then create the desired visual.

Best Regards,
Angelia

Anonymous
Not applicable

Hi there

Thats what I did  - I guess I didnt realise that for this to work on PowerBI Service I need to create a custom visual myself 😞

Never mind...

Hi @Anonymous,

You can create a R visual in Power BI deskyop, then publish it to service. We can not create a R visual in Power BI service.

Thanks,
Angelia

@Anonymous it does make sense and i think you probably would have to because the only way to use a visual in power bi is to import it in, you can't generate it





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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.