Data Query Timeout

[Anonymous]

Hi, I'm currently trying to load several Python datasets. However, it's taking so long to load that the queries failed with the error - ADO.NET: Python execution timeout. The script execution was terminated, since it was running for more than 1800000 miliseconds.

Is there any way to work around this?

[v-yulgu-msft]

Hi @Anonymous,

It is a limitation that preparing and running a Python script longer than 30 minutes times out will lead to such an error. Loading too much data might reduce the execution performance that cause this problem. Here is a blog listing Performance Tips for R and Python Scripts in Power BI

Best regards,

Yuliana Gu