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,

When I tried to put in my windows credentials, it took forever and was never successful at this step.

After a few tests, now I can partly reproduce the issue(not totally the same as yours). The R data source cannot be refresh via the Personal Gateway, but I will receive an error each time when I select the R Dataset under Datasets Setting in Power BI service, and I don't have the option to edit the credentials, as it is not shown under Data Source Credentials tab and the PC name is also not shown for my Personal Gateway.

 

 

 

While I will report the issue internally and post back if there is any feedback, I would also suggest you create a support ticket on Power BI Support page for better assistance in this scenario. :smileyhappy:

 

Regards