R offline in my connections and gateways

[dragonus12345]

Hi,

I use R in my powerquery in PBI Desktop and it has always been online since before today. 

However, from today onwards, i keep encountering the fact that i can't connect to it... not sure how to get it back online? I can't find anything about this online. and my machine is already on (other tables/csv files etc are all ok)

Would require the help of the experts here 🙂

[v-tsaipranay]

Hi @dragonus12345 ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved? If you still require support, please let us know, we are happy to assist you.

Thank you.

[v-tsaipranay]

Hi @dragonus12345 ,

Thank you for reaching out to the Microsoft Fabric Community Forum.

Could you please let us know if the issue has been resolved? I wanted to check if you had the opportunity to review the information provided by @Ritaf1983 and @lbendlin  . If you still require support, please let us know, we are happy to assist you.

Thank you.

[Ritaf1983 · Accepted solution]

Hi @dragonus12345 

From your description it sounds like the R data source is appearing as Offline under Connections and gateways, even though your machine is on and other sources (CSV, tables, etc.) work fine.

A few things to verify:

Check R settings in Power BI Desktop
Go to:
File > Options and settings > Options > R scripting
Make sure the R home directory still points to a valid R installation (sometimes IT updates or removes R silently).
Try loading a simple R script as a new data source:

data.frame(X = 1:10)

If this already fails in Desktop, the issue is local R, not the gateway.

Gateway status
In the Power BI Service, check under Manage connections and gateways that the gateway itself is Online.
If the gateway is Offline, restart the On-premises data gateway (or the personal gateway app) on the machine hosting it.

R installation on the gateway machine
For scheduled refresh, R must also be installed on the gateway machine.
Ensure that:

R is installed there,

The version is compatible,

The gateway configuration points to the correct R installation folder.

Gateway/Desktop version mismatch
If Desktop was updated recently but the gateway is still on an older version, R scripts can suddenly fail.
Update the gateway to the latest version.

Tenant settings
Your Power BI admin should verify under Admin Portal > Tenant settings that R scripting and R visuals are still enabled.

If you can share:

a screenshot of the exact message, and

the version numbers of Power BI Desktop and the gateway,
it will help narrow the root cause.

And if none of the above resolves it, the next step is to open a formal support ticket with Microsoft so they can check the backend side of your tenant/gateway configuration.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[lbendlin]

R and Python scripts mandate the use of a personal gateway.  They will not work on an Enterprise gateway.