Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 37 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 130 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |