Forum Discussion
R script not working in Service
#"Removed Duplicates" = Table.Distinct(#"Changed Type2", {"Column X"}),
#"Run R script" = R.Execute("# 'dataset' holds the input data for this script#(lf)#(lf)write.csv(dataset, file = ""C:/Users/userX/Downloads/data.csv"")",[dataset=#"Removed Duplicates"]),
ReturnValue = #"Removed Duplicates"
in
ReturnValue
I use R script to export data to a csv file which works great when I open the file in desktop. When published to the service it doesn't function and there are no errors returned. I've tried changing the file destination to a public network but doesn't seem to change the outcome. Any ideas?
Hi troyhimes ,
For security/permission reasons, you can't execute r script(power bi service side) to loading external data source or do export/import operations on specific path.
Please see：
Export the data - considerations-and-limitations
Create and use R visuals in Power BI
As a workaround,you may refer to : Export CSV file to OneDrive Using R Scripting in Power BI Service
Hope it helps,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hey troyhimes ,
to execute R-Script from inside Power Query you need an on-premises gateway installed in Personal mode.
It's also necessary that R is installed on the same machine as the gateway.
I assume this thread provides some useful links: https://community.powerbi.com/t5/Desktop/Refreshing-R-Script-on-Personal-Gateway/td-p/1064902Here you will find more information about the personal gateway: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
Regards,Tom
Thanks for the links TomMartens but the on premises gateway in Personal Mode and R are both installed on my computer.
Hi troyhimes ,
For security/permission reasons, you can't execute r script(power bi service side) to loading external data source or do export/import operations on specific path.
Please see：
Export the data - considerations-and-limitations
Create and use R visuals in Power BI
As a workaround,you may refer to : Export CSV file to OneDrive Using R Scripting in Power BI Service
Hope it helps,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
