Add "Run R Script" option to Excel 2016 and Excel 2013 "Power Query" add-in, as it is for Power BI.
In July 2016, a "Run R Script" option was added to Power BI Desktop. This option would be a huge benefit to have in Excel 2016 and Excel 2013 Power Query add-in also.
Thanks for your passion around this. We’ve been discussing this item off and on for some time now and we’d love to get your input.
The reason we’ve resisted this is because the R runtime & various packages (and updating their versions) aren’t straightforward for other users to install. This limits sharing such queries across a workgroup.
What do you think?
For others reading this that’d like us to prioritize this work, please be sure to add your vote since we’re prioritizing our backlog based on these.
Lead Program Manager
Yury Yafimau commented
Not bad. Not sure it will be ever done. The feature is likely to change Excel like Pivot table did in the past.
Imke Feldmann commented
Wouldn't it be a good start to give us R in Power Query like in the query editor (!!) in Power BI (https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-in-query-editor/) ?
Can well imagine that the integration of plots into Excel is more complicated, but the integration into the M-scripts must be almost straightforward - or am I mistaken here?
Ghazanfar “GJ” Abidi commented
I believe this can significantly strengthen Excel's position as a data tool. Should've been done already.
Yes, R-Script with excel power query is the natural evolution, its already doing great in power bi, please add the R.Execute command to excel power query too.