cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vrv
Helper I
Helper I

R script saving a dataset to a csv file on at a network location

Hi all,

does anybody know how exactly am I supposed to save a table (dataset) to a csv on some network location using an R Script?

 

Basically, I followed the instructions here: Solved: Can PowerQuery write data back out? - Microsoft Power BI Community

# 'dataset' holds the input data for this script
# set the working directory to the location in which you want the transformed CSV saved 
setwd("C:/temp")
# write out the transformed data set 
write.table(dataset, file="transformed_data.csv", sep = ",", row.names = FALSE)

but it only works when I save my sample.csv (the equivalent of transformed_data.csv above) locally to the machine where I developed the Power BI report and subsequently installed R. 

Th eOptions for R do not see any network location.

 

Is there a way to start seeing those network locations:? I do have access tpo those locations through my domain user, service aacount(s) in the Active Directory, etc.

 

Thanks,

vrv

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @vrv,

R script is possible to execute script on power query side to export file.
Notice, these types of operations(e.g. looping folder/file, save/edit the file, access to the remote resources) should only work on the device that you have enough permissions. If you publish the report to the power bi service side, these operations will be blocked due to security reasons.

Power BI Security - Power BI | Microsoft Docs

Regards,

Xiaoxni Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @vrv,

R script is possible to execute script on power query side to export file.
Notice, these types of operations(e.g. looping folder/file, save/edit the file, access to the remote resources) should only work on the device that you have enough permissions. If you publish the report to the power bi service side, these operations will be blocked due to security reasons.

Power BI Security - Power BI | Microsoft Docs

Regards,

Xiaoxni Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

vrv
Helper I
Helper I

Hi all,

Is there a more specialised forum where I can find an answer to my question?

 

Thanks,

vrv

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors