Forum Discussion
luojiandan_bi
Helper I
Helper IPower Query table to SQL Server by R script,why is that.0 extra
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};...
using format function is ok:
dataset$cust_id <- format(dataset$cust_id)
v-kelly-msft
Community Support
Community SupportHi 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!