Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

R Integration with Power BI - Scheduled Refresh

I have created R-Script as a data source (Note: I am not using the "Run as R-Script" feature but the R- Script as a data source itself) in my Power BI desktop file. I then published the PBIX file to ...
Need Help
Tutorial Requests
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Anonymous,

     

    To download the PGW that supports R Script as a data source, use this link: http://download.microsoft.com/download/D/D/C/DDC1B1CA-59A3-422E-9C82-4AF38A9B9F97/PowerBIGateway.exe

     

    Note that this PGW version is being retired by July 31st and you will need to download and install the new “On-premise data gateway (personal mode)” (more info) by then for refresh to continue to work. This new version of the Gateway is already available but R Script support is still not available in that new version. The team are enabling support for it over the next few weeks, so there will be zero downtime as long as you migrates to the new version when released in mid-July. :smileyhappy:

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Anonymous,

 

To download the PGW that supports R Script as a data source, use this link: http://download.microsoft.com/download/D/D/C/DDC1B1CA-59A3-422E-9C82-4AF38A9B9F97/PowerBIGateway.exe

 

Note that this PGW version is being retired by July 31st and you will need to download and install the new “On-premise data gateway (personal mode)” (more info) by then for refresh to continue to work. This new version of the Gateway is already available but R Script support is still not available in that new version. The team are enabling support for it over the next few weeks, so there will be zero downtime as long as you migrates to the new version when released in mid-July. :smileyhappy:

 

Regards

Dimitar's avatar
Dimitar
Frequent Visitor
7 years ago

v-ljerr-msft

 

Hi and thanks for the explanations. We followed the documentation and integrated an R script for some data treatments.

As per your explanations we installed an "On-premise data gateway (personal mode)" on our server and were able to refresh the reports on the service. 

The real problem now is that this 'Personal mode' gateway is much less stable than the standard "On-premise data gateway" => we have a lot of unsuccesful dataset refreshes, the Personal gateway stops working when surcharged ... This is requesting much more maintenance, which is pitty as the initial idea of R scripts integration is great, and the standard "On-premise data gateway" is much more robust.

 

Is there a plan to implement the Refresh of datasets integrating R scripts ? This is really needed to consider this feature as ready for production?

Thanks,

Dimitar