Using R script and working with multiple developers

[jaryszek]

Hi Guys,

I am using R script and managed to set up the connection for it within personal gateway for specific power bi user.

I logged in second laptop to power bi and i could't use the gateway because my first laptop where i cnfigured R source was turned off, which is obvious behaviour.

After running first laptop with gateway set up I have logged in to the same power bi user account and managed to refresh connection.

If this will work per 1 logged user? 
If i would have more users can i use the same personal gateway to laptop where my R code is set up? 

I know that enterprise gateway will not work with python or R scripts...
Best,
Jacek

[v-sgandrathi]

Hi @jaryszek,

Thank you for your question regarding the use of R scripts with Power BI and managing Personal Gateway access for multiple users and machines.

To clarify, the Power BI Personal Gateway is linked to both the specific machine and the user account it was set up with. It operates only when the original machine is on and the configured user is signed in. Logging into the same Power BI account from a different device will not make the gateway available unless the initial machine is running and the gateway service is active.

Add on, sharing access to the dataset or workspace does not provide access to the Personal Gateway. Other users, even with report or workspace access, cannot use the gateway for scheduled refreshes. This limitation makes the Personal Gateway unsuitable for collaborative or team-based development involving R or Python.

As the Enterprise Gateway currently does not support R or Python, alternative solutions are advisable for team environments. One option is to deploy the Personal Gateway and R environment on a dedicated, always-on machine or server, managing all publications and refreshes through a single Power BI user account. However, this approach may not scale effectively for larger teams.

For improved collaboration and maintainability, consider running your R or Python scripts externally and saving the results to a file or database, which Power BI can then access. This setup enables the use of the Enterprise Gateway for refreshes and supports a more robust and collaborative workflow.

While Power BI Dataflows do not natively support R or Python, preprocessing data externally and feeding it into a dataflow can help centralize and share clean data among multiple developers and reports, enhancing reusability and version control.

You may refer to the official Microsoft Fabric documentation links for further information:
Use a personal gateway in Power BI - Power BI | Microsoft Learn
On-premises data gateway FAQ - Power BI | Microsoft Learn

If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

Thank you.

[lbendlin]

Technically you can give other users access to your Personal Gateway.  But that only makes the problem worse, in my opinion.

What is the value-add of the R scripts?

[jaryszek]

Technically you can give other users access to your Personal Gateway.

How? 

[jaryszek]

Using environment windows variable. Not having to change parameter every time while opening report.