Forum Discussion

hervekoap's avatar
hervekoap
Regular Visitor
4 years ago

R script in PowerBi failed can't display the visual

Hi collegues   I am using R3-3.1    I am adding a componound R and when I drag and drop a column ( InitialSidFrom)my R component says     What CAn I do to solve this issue?   thanks  ...
Need Help
hervekoap's avatar
hervekoap
Regular Visitor
4 years ago

Hi Ibendlin

 

Here you will find the resul of my test 

 

my real goal is to export data through a R componoud

 

let me know if I am wrong

 

I am a beginner for the R componound

 

kind regards::::

 

# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:

dataset <- data.frame(Column1, Column2)
dataset <- unique(dataset)

# Paste or type your script code here:


require(gdata)
write.table(trim(dataset), file="e:/temp/r4.csv", sep = "\t", row.names = FALSE)
plot(dataset);
  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    why do you call the file csv if you use tab as a delimiter ?  🙂

     

    what's the point of using trim ?

     

    This works fine for me.

     

    write.table(dataset, file="c:/temp/r4.csv", sep = ",", row.names = FALSE)