Refreshing R Script on Personal Gateway

[rigelng1995]

Hi 

I have read a lot of similar posts but none really explaining how to set up it properly. I have created a powerBI file which uses R to transform some of its data in the one of the steps. Everything works fine locally but doesn't work once it is published to PowerBI.com for a scheduled update. The error I get is that the extensionDataSourceKind "R" cannot be added to the gateway. 

I have read posts where enterprise gateway doesn't work with scheduled refreshed on R/Python Scripts - So I have installed a personal gateway to the remote server. (The Enterprise Data-Gatway  is also connected to the same remote server.) Both gateways are showing but the R extended datasource is connected to the enterprise data gateway. 

The question is how do I get powerBI to recognize/move the extensionDataSourcedKind under the personal data-gateway or have I got the logic of this completely wrong? If so how should I arranged the set up so that I can schedule refresh on this file on powerBI.com. 

Any help is appreciated

Thanks

Rigel 

Gateway Setup

[V-pazhen-msft · Accepted solution]

@rigelng1995 

Follow this step by step to set personal gateway: https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode

A post that might helpful: https://community.powerbi.com/t5/Power-Query/Refresh-R-Scripts-with-Personal-Gateway/td-p/434177

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  

[amitchandak]

@rigelng1995 ,

Refer: https://powerbi.microsoft.com/fr-fr/blog/on-premises-data-gateway-august-update/