Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Hi @Sowmiya
You could have a try with the following suggestions
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.