Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Save CSV output from R script to Sharepoint OR OnDrive

Hi Team, Need help to write R Script in Query Editor (PowerBI) which will save CSV output into Sharepoint or One Drive, Please asssit! 

  • Hi Anonymous ,

     

    If you have set up OneDrive on your local machine, you can just save the file on local and then it will sync to online automatically.

    # 'dataset' holds the input data for this script
    write.csv(dataset,"C:/Users/Admin/OneDrive - xxxx/Icey Zhang/output.csv")
    output = dataset

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Any Comments?

  • Icey's avatar
    Icey
    Community Support

    Hi Anonymous ,

     

    If you have set up OneDrive on your local machine, you can just save the file on local and then it will sync to online automatically.

    # 'dataset' holds the input data for this script
    write.csv(dataset,"C:/Users/Admin/OneDrive - xxxx/Icey Zhang/output.csv")
    output = dataset

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.