speed up R visual report

[Anonymous]

so my company has reports that utalize custom R visuals to display what is known as the loess regression curve, we share the report to our clients through link from share report > embed report > website or portal, the problem is that the visuals takes atleast around 33 seconds to show up, ideally we would like 4 to 5 secs of loading time, any one know a way to speed this up? or perhaps another native power bi visual to display smooth regression curves?

[Anonymous]

Hi  @Anonymous ,

You can from the following aspects:

1. You run these formulas in the R script editor and Power bi, and compare them. If the R script editor and Power bi are the same, it may be related to your formula. You can optimize the formula. If the performance of the R script editor is superior In Power bi, it may be related to Power Bi’s embedded R script edito.

2. You can switch the connection mode to Import mode, whether the operation will improve performance

3. There may be less memory, please increase the amount of RAM and try again(When power bi calculate on some complex formulas or loading huge amount of data, it will cost lots of resouces).

4. Upgrade Power BI Desktop to the latest version, and then republish to Power BI Service.

This is the related document, you can check it out:

https://community.powerbi.com/t5/Desktop/Improve-performance-of-R-script-in-Power-BI/td-p/335952

https://dataveld.com/2018/11/10/5-performance-tips-for-r-and-python-scripts-in-power-bi/

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.