Forum Discussion
Using R script and working with multiple developers
Hi jaryszek,
Go to Manage connections and gateway, click on the on-prem gateway
after clicking on manage users you can give access to that gateway to another user
The other user can now access your gateway.
Thank you.
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.
Hi jaryszek,
Thank you! We’re glad to have you in the Microsoft Fabric Community and feel free to drop by anytime you need help or want to share ideas.
Thank you.
Hi jaryszek,
Following up to check whether you got a chance to review the suggestion given.If it helps,consider accepting it as solution,so that it will be helpful for other members of the community who have similar problems as yours to solve it faster. Glad to help.
Thank you.
