Failed to use the selected gateway. Please make sure the gateway is up and running and try again

[tanehome1]

I tried to connect the dataset of "R script" to the gateway (use personal mode), but is not successful and found the message. 

I checked the datasets and gateways status and all is online.  Please kindly assist.  thanks.

[lbendlin]

From the screenshot it looks like you are already connected to the Personal Gateway. That gateway also needs to have a connection definition for the SQL data source.

Ignore the Enterprise gateways, they are not applicable to your scenario.

[tanehome1]

i've deleted the enterprise gateway and still can't add the connection to personal gateway even when try to create a new connection (not showing the personal gateway to can select) in "gateway cluster name"

[lbendlin]

not sure. If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[tanehome1]

Hi All,

Regarding, the gateway finally Microsoft has replied my ticket as this option not available now and may be added next releases (reply below)

(We informed you that, according to the below documentation, R and Python scripts only work with the personal mode gateway. However, in the personal mode gateway, we cannot refresh two data sources simultaneously. You asked if it is possible to use the enterprise gateway for the R script, but unfortunately, it is not supported. We provided you with an idea forum where you can raise this suggestion.)