Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Community,
I am planning to export data from Power Query to SQL Database through R Script. My Database has more than 30 lakh data. I am getting time our error while exporting the Power Query database to SQL database. I have researched in community I got syntax timeout=#duration(0,0,300,0). I am not sure about where to add this syntax and wheather this works?. So please assist me to rectify this error.
Thanks In Advance,
Sowmiya
Hi @Sowmiya ,
I'm afrad the timeout=#duration(0,0,300,0) is the function in M Query instead of R script.
From this similar thread, it seems that it is not available to customize timeout setting for R script execution in desktop right now.
I'm not good at R script, bymy research, you may try the R function timeout(seconds) .
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.