Power Query table to SQL Server by R script,why is that.0 extra

[luojiandan_bi]

In Power Query Editor, the text string is: 123547126811

Why is the text string in SQL Server: 123547126811.0?

R Script: 

library(RODBC)
conn <- odbcDriverConnect("driver={SQL Server}; server=localhost;Database=**;uid=uid;pwd=password")
odbcClearError(conn)
sql="Delete T From
 (Select Row_Number() Over(Partition By cust_id order By cust_id) As RowNumber,* From tmp)T
 Where T.RowNumber > 1"
sqlSave(conn, dataset, tablename="tmp",rownames=FALSE, safer=FALSE, append=TRUE,fast=TRUE)
sqlQuery(conn,sql)  #delete duplicate data.
close(conn)

because The PowerQuery M code run twice,so run delete duplicate sql in R Script.

[luojiandan_bi · Accepted solution]

using format function is ok:

dataset$cust_id <- format(dataset$cust_id)

[v-kelly-msft]

Hi @luojiandan_bi ，

Check whether the data type has been changed automatically in power query,if so,close it.

Check the reference below:

https://a4accounting.com.au/stop-power-query-from-automatically-setting-data-types/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[luojiandan_bi]

wait for helping online.