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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jnat5
New Member

Custom Visual Performance is lacking?

I am currently trying to create my own custom networking visual using either of the following R packages (using the pbiviz rhtml template):

However I'm finding performance is extremely slow, even on a very small amount of data (8 nodes), so that when users filter the report does not have a good UX.

 

The visualisation works fine in RStudio, hence I think it's an issue with Power BI. I've also tried only importing the packages I need, and doing absolutely minimal data processing (just selecting columns then removing any unused data frames out of memory). It's also slow in the Power BI Service.

 

Has anybody else experienced this isse with R custom visuals? Any help would be appreciated!

 

I was thinking maybe using the Javascript package underneath would be more performant - vis.js (i.e. the issue may be something with Power BI and R)?  

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @jnat5,

Did dm-p 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
dm-p
Super User
Super User

Hi @jnat5,

R visuals are delegated to an external interpreter by the visuals layer, which is web-based - this is either your local interpreter (if using Desktop) or an interpreter in the Service hosted by MS (if published).

There is a 'round trip' / 'cold start' cost often associated with this as it is managed over HTTP and processed into a static image (or HTML if  using RHTML in the custom visuals SDK) before being rendered in the DOM of the developer visual as such.

You will indeed get much better performance if you can work directly with the TypeScript SDKs as this is 'native' to Power BI.

I got into custom visual development in a similar way - started with R and found this performance bottleneck somewhat frustrating, so now I do all dev in TypeScript. Highly optimised code can be very performant.

If you don't want to go full web dev, and can manage with frameworks like Vega-Lite, I'm working on a visual called Deneb, which may bridge this gap.

Regards,

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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