We have a report wich loads data from Azure Cosmos Document DB. Inside Power Query we use an R script to process the mentioned data. All works fine on Desktop Version, also the data refresh.
Now the problem is that when published the report, data refreshment isn't possible. Power BI service asks to install a personal Gateway, although there is no need to upload any data from a personal source.
If we delete the R script for testing, the refresh is working fine, and we can set a refresh shedule.
What's the problem?
Thanks in advance for your apreciated help.
Power BI service requires on-premise data gateway (personal mode) to access R for data to updated, as R is on-premise. You need to install on-premise data gateway (personal mode) where the R runs. For more information, see: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-desktop-r-in-query-editor/
Thanks for your hint.
For me it's no solution, because the whole data comes from the cloud only (azure document db). So an R script running on that data inside Power Query should not require any local access!
It's indeed need personal gateway. You can go to Data Source Settings in Power BI desktop, you will find a R data source, which is on-premise. After publish the report to service, the personal gateway needs to be installed on the same machine hosts R to make the Power BI service access the R.
Thank's for your answer. I understand this all.
But I'am not happy at all with this solution. It diminishes the value of R to use with PBI.
Data from cloud should fully be processed inside PBI service, without the need of an on-premise gateway, also if there is an R script involved, which processes only that data. This means that the R engine should run on PBI service.
My whisch is, that Microsoft does expand the R integration to this use case.
It's true that the cloud data adoesn't require any gateway. But as long as the report contains on-premise data source, gateway is required. Unfortunately, R data source is on-premise now, and doesn't have cloud version. So I have to say we need to install gateway for this kind of report to be refreshed in Power BI service now.
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.