The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
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.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
52 | |
42 | |
23 | |
22 | |
18 |