Forum Discussion
Usage of R query in published report
Anonymous,
When you use R in Query Editor of Power BI Desktop, you are actually accessing on-premises R data source. You can go to File > Options and settings > Data source settings to check that the R data source is added in the PBI file.
In this case, you would need to install personal model gateway on the machine where R is installed in order to access R for data to updated. For more details, please review this article.
And there is a similar thread for your reference.
https://community.powerbi.com/t5/Integrations-with-Files-and/Refresh-Failed/m-p/479130#M18742
Regards,
Lydia
Anonymous,
When you use R in Query Editor of Power BI Desktop, you are actually accessing on-premises R data source. You can go to File > Options and settings > Data source settings to check that the R data source is added in the PBI file.
In this case, you would need to install personal model gateway on the machine where R is installed in order to access R for data to updated. For more details, please review this article.
And there is a similar thread for your reference.
https://community.powerbi.com/t5/Integrations-with-Files-and/Refresh-Failed/m-p/479130#M18742
Regards,
Lydia
Thank you very much for the info Lydia.
One thing I don't totally understand is why the visualisation side doesn't need an R gateway and the query part does.
Is there any idea or any developent roadmap in which the option of integrating R query "natively" (without a gateway) is cosidered?
Anonymous,
You should have used R packages that Power BI Service supported in your R visual. Thus, it doens't require access to local R service and gateway is not required in this case. See supported R packages in Power BI Service in the article below.
https://docs.microsoft.com/en-us/power-bi/service-r-visuals
Regards,
Lydia