Forum Discussion
R script configuration in On Premises Gateway
Hi community,
Hope you all are doing well.
Recenlty I tried configuring Gateway on my server.
I'm using 2 sources in my PBIX file,
SQL server and R script
I was successfully able to create a connection for SQL and link it with the Gateway.
I'm not able to create a connection for R script as there is no R connector in Connection list and cannot be added in Gateway.
Upon doing some R&D I got to know, R script only works on On premises Gateway Personal Mode.
Below I've added snip of the error:
Please help me out on finding a solution for this or any workaround if available.
Niraj_vora0106
You are right, Python and R scripts only works with personal gateways. You can vote for the idea and if it gets enough votes then may be Microsoft will consider this,https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=8f209a02-4ac9-4d54-942e-2476cd38c48e
and as a workaround may be you can write your output files to a storage location like onedrive/sharepoint and use them your semantic model.
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
2 Replies
Niraj_vora0106
You are right, Python and R scripts only works with personal gateways. You can vote for the idea and if it gets enough votes then may be Microsoft will consider this,https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=8f209a02-4ac9-4d54-942e-2476cd38c48e
and as a workaround may be you can write your output files to a storage location like onedrive/sharepoint and use them your semantic model.
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Thank you for your response.
Unfortunately I couldn't find any other workaround and have informed user the workaround you provided.
