Usage of R query in published report

[Anonymous]

In a report, I load files from a Sharepoint folder and then I transform the data using the R query editor. I also use an R visual in the same dashboard.

If I only use the R visual and don't perform the transformations using R query I can publish the report and schedule a reload. However, if I use R query the reload scheduling asks for a gateway. 

I don't use any external data, so, why is there a need for a gateway? 

Why there is no need for a gateway when rendering an R visual and not for running an R query?

Thanks in advance.

[Anonymous · Accepted solution]

@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]

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]

@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