Forum Discussion
PBI report refresh from R and JSON on Linux machines
v-qiuyu-msft thank you for the reply. I did confirm using personal gateway works for R refresh. However, I don't have a MS machine that can be on all the time as required by personal gatey. So my goal is to find a way to put R and its JSON input into Azure cloud service. Is there a way to ask PBI service refresh to look in Azure for R installation and sources?
Hi liucpaulpbi,
When we use R script in Power BI desktop, R needs to be installed on the machine which has Power BI desktop runs. It means R data source always be on-premise, can't be host in cloud.
In your scenario, as the personal gateway can't be online every time, you can refresh the pbix file in desktop then republish, or when personal gateway is online, manually refresh the dataset in Power BI service to get updated data. One more option is installing R and personal gateway, place Json file in Azure VM, but keep Azure VM always online will cost too much.
Best Regards,
Qiuyun Yu