The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have a PowerBI dashabord template that worked very well in the past, and it worked well for 3 weeks ago. However, I got this errors ADO.NET:R execution timeout. The script execution was terminated,since it was runnning for more than 2 hours. Anyone can help?
Thanks for the reply from lbendlin.
Hi @weifl ,
This error occurs because the execution time of the R script is too long and exceeds the allowed time limit.
R visuals in Power BI Desktop have some limitations, such as:
Data sizes: Data used by an R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used, and a message is displayed on the image.
Output size: R visual has an output size limit of 2 MB.
Calculation times: If an R visual calculation exceeds five minutes, it causes a time-out error.
Refreshes: R visuals are refreshed upon data updates, filtering, and highlighting. However, the image itself isn't interactive and can't be the source of cross-filtering.
For details, please refer to: Create advanced analytics and visualizations using R scripts - Power BI | Microsoft Learn
For some suggestions on improving performance, refer to: 5 Performance Tips for R and Python Scripts in Power BI - DataVeld
Best Regards,
Zhu
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I assume you mean a report (there are no dektop dashboards).
What does your R script do?
User | Count |
---|---|
65 | |
61 | |
60 | |
53 | |
27 |
User | Count |
---|---|
181 | |
88 | |
70 | |
48 | |
46 |