R script configuration in On Premises Gateway

[Niraj_vora0106]

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.

[tharunkumarRTK · Accepted solution]

@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

[Niraj_vora0106]

Hi @tharunkumarRTK 

Thank you for your response.

Unfortunately I couldn't find any other workaround and have informed user the workaround you provided.