Timeout Error while exporting data to SQL

[Sowmiya]

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

[v-piga-msft]

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