cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
akj2784 Post Partisan
Post Partisan

Performance issue with R custom Visual in Power BI

Hi,

I have observed R Custom visual and also Custom visual created using pbiviz runs extremely slow in Power BI.

I just have 10 records and few data manipulation columns.

 

It takes more than 20 secs to load the report.

 

Any known performance issue ?

 

Regards,

Akash

6 REPLIES 6
Moderator v-yuezhe-msft
Moderator

Re: Performance issue with R custom Visual in Power BI

@akj2784,

Could you please share sample data of your table and the R script you use? Also what is the custom visual do you use? How many idle RAM in your machine?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
akj2784 Post Partisan
Post Partisan

Re: Performance issue with R custom Visual in Power BI

I am trying to plot waterfall chart using plot_ly library. We have 128 GB RAM on the server. And have sufficient idle RAM.

That custom visual is totally custom created using pbiviz by following the below URL

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

If I raise an SR will microsoft support custom Visual issues ?

 

Regards,

Akash

ThomasFoster Solution Specialist
Solution Specialist

Re: Performance issue with R custom Visual in Power BI

I contacted MS support before about custom visual issues and was told that it was outside of the scope of the support included in a pro license. 

 

Regarding your specific case, it depends on what you are doing in your R code, what data you are loading etc.

 

The only generic advice I can offer is, does it perform similarly poorly in another enviroment such as RStudio, does it perform differently on desktop vs the service/report server.

 

akj2784 Post Partisan
Post Partisan

Re: Performance issue with R custom Visual in Power BI

Thanks Thomas. 

As I mentioned, it works fine in RStudio. And total number of records r just 10.

 

But when I see the same report in Power BI Service/Desktop it is very slow.

ThomasFoster Solution Specialist
Solution Specialist

Re: Performance issue with R custom Visual in Power BI

You mentioned you are doing data manipulation in the R script, one suggestion would be do do this before laoding the data into the visual.

 

One thing to check is that your power bi desktop is using the same version of R as your Rstudio as there may have been performance improvements in some updates to R that RStudio is using that power bi may not be if it is running of an older version.

Highlighted
Goofr Advocate IV
Advocate IV

Re: Performance issue with R custom Visual in Power BI

Hi,

 

Any news on this topic?

 

Thanks,

 

Frank

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors