Forum Discussion
PBI report refresh from R and JSON on Linux machines
My company has JSON data created on Linux, and I transform these JSON with R script into Power BI desktop, and publish to Power BI report for customers. But I do not want to use Windows laptop to install gateway for refresh BI dataset/report in the cloud.
Can I put JSON and R in Azure, and use BI Desktop to publish dataset/report? I assume BI report refresh through Azure is seamless.
4 Replies
Hi liucpaulpbi,
R data source requires personal gateway to refresh, it's not supported to refresh without personal gateway. As long as you keep the personal gateway to the latest version (now it's On-premises data gateway (personal mode)) and keep it's online, set schedule refresh for the dataset can have data updated smoothly. See: Creating visuals from R script data.
Best Regards,
Qiuyun Yuv-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
