I have a very basic R Script I am running in PowerBI to export a file, from Power Query:
write.table(dataset, file="Pam_list.csv", sep = ",", row.names = FALSE, append = FALSE, quote= FALSE)
The issue I am having is that the Customer Number has leading zeros: 0000048014.
When I export to a .csv, open with notepad, it drops the zeros so the result is 48014.
Any suggestions would be great, I am a n00b so I will probably have more questions.