Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi everyone. I am having trouble to define my architecture with a new requirement of my boss. Let me give some context.
I am running an on premise gateway with sql server, mysql and excel files in three different files. Now a requirement arrives and forced me to use R script for Data entry (no other way to do it). So I created a new file with this solution and stuck in de refresh. The only way to refresh R is with personal gateway.
Can I install Personal Gateway in the same server that has On Premise Gateway? How should I proceed with this if I only have one server available?
Should I migrate all the other models to upgrade with Personal Gateway?
Regards,
Happy to help!
Solved! Go to Solution.
Hi @ibarrau,
As you use the R script to get data, to refresh on Power BI service, you need a Personal Gateway installed on the machine where the file is located, and where R is installed; the Power BI service must access that workbook and re-render any updated visuals. See: Creating visuals from R script data.
You can install the personal gateway on the same machine which hosts the on-premise data gateway. To install personal gateway, see: Power BI Gateway - Personal.
Best Regards,
Qiuyun Yu
Hi @ibarrau,
As you use the R script to get data, to refresh on Power BI service, you need a Personal Gateway installed on the machine where the file is located, and where R is installed; the Power BI service must access that workbook and re-render any updated visuals. See: Creating visuals from R script data.
You can install the personal gateway on the same machine which hosts the on-premise data gateway. To install personal gateway, see: Power BI Gateway - Personal.
Best Regards,
Qiuyun Yu
Thanks Qiuyun Yu, it seems to be there is no longer problem with this. It broke so many times in the past that I was afraid to test it. Now is so much stable. I run both gateways on the same machine without problems.
Happy to help!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.