R Script Visual slow in Service

[Goofr]

Hi,

I have a simple pbix file with manually entered data, 5 rows (period and percentage) wich I display in an R script visual.

Ones published to the Service, the report takes 4 to 5 seconds to load the visual.

What can I do to improve this load time?

You can download the file here:  pbix R visual

Thanks in advance,

Frank

[v-xicai]

Hi @Goofr ,

1.If you run these formula in R script editor and power bi, what editor has poor performance?

    If R editor has similar performance as power bi, this issue may related to your formula, please try to optimization your formula.(you can try to post to R script related forum to get better support of optimization)

    If R editor has better performance than power bi, I think it may related to embed r script editor of power bi.

2.If you switch to import mode, does this operation increase performance?

3.Please increase RAM amount and try again.

4.You may upgrade the Power BI Desktop to the latest version, and then republish to Power BI Service.

There is a similar case you can refer to :https://community.powerbi.com/t5/Desktop/Improve-performance-of-R-script-in-Power-BI/td-p/335952.

You can also refer to the link to improve the performance:https://dataveld.com/2018/11/10/5-performance-tips-for-r-and-python-scripts-in-power-bi/ .

Best Regards,

Amy

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

[Goofr]

Hi,

In Power BI Desktop everything runs smoothly.

It is wen I upload the report to the Service, it becomes slow.

The R Visual itself contains one formula: plot(x, y).

Import has the same effect, fast in Desktop, slow in Service.

Thanks,

Frank