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 August 31st. Request your voucher.
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?
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