Forum Discussion
R script not working in Service
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.
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/1064902
Here 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.