Forum Discussion

weifl's avatar
weifl
New Member
1 year ago

Power BI desktop dashboard error: timeout

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? 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    I assume you mean a report (there are no dektop dashboards).

     

    What does your R script do?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.