Solved: Power BI, R and oData

Z7-852 · ‎07-11-2017

I need to have sceduled refreash online for my report. Most of it's data is gathered from Dynamics CRM with oData and few tables contain R scripts as part of query.

Power BI online cannot use R natively so I will need some other solution for this. Second problem arise when I try to link oData source to gateway. For some reason this isn't possible.

How do I refreash R script as part of power bi online?

v-ljerr-msft · ‎07-12-2017

Hi @Z7-852,

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 31^st 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.

Regards

View solution in original post

v-ljerr-msft · ‎07-12-2017

Hi @Z7-852,

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 31^st 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.

Regards