Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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,
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.