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!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors