R Visual Script Execution Time out

[Sowmiya]

Hi Community,
Help me with R-Script to extend the timeout.

I am having 21,00000 rows of Data. On Exporting this data into MySQL using R - Script, 900000 rows of data got exported into MySQL and Remaining rows are not exported bacause of Timeout. How to extend the timeout in my R-Script.

Script I have used,
library(RODBC)
conn <- odbcDriverConnect("driver=MySQL ODBC 8.0 Unicode Driver; server=localhost; Database=test;uid=root")
odbcClearError(conn)
sqlSave(conn, dataset, tablename="File Name in Here",rownames=FALSE, safer=FALSE, append=TRUE)
close(conn)

If there is no way to extend the timeout in R-Script,
Using R-Script how to export 1st row to 900000th rows and then append 900001 th row to remaining 21,00000 row.

Thanks in advance,
Amz

[v-juanli-msft]

Hi @Sowmiya 

You could have a try with the following suggestions

https://community.powerbi.com/t5/Power-Query/Export-huge-amount-of-data-from-one-pbix-file-and-impor...

Export Power BI Desktop data to SQL Server

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.