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
Running R script directly from Excel is really adding value.
I have devopped an Excel Add-in, used in my company, which allows that, you can either write your own script on the data selection, or let the macro create your scripts for your data set thanks to a user interface. The output chart or table is copied in Excel.
The add-in is testing if all the required packages are installed and do automatically the needed installations, so the user only has to install R and doesn't care about packages.
So I think you should add "Run R Script" option to Excel "Power Query" add-in and manage missing packages installation to make it easy for users.
I understand your reason for resisting, but I think maybe you could solve this problem if you add to "R or Python for Excel" a mechanism like Nuget in Visual Studio. It would be not difficult to add libraries. But I think at least you should provide a kind of AddIns like RRunner , that can serve as a bridge between Excel Objects an R Objects.
Christopher N Graham commented
This is definitely needed and would greatly help with the continued use of Excel in my line of work. There is a gradual shift to R for more complex analysis, but with the ability to call R from Excel easily it would keep Excel as an option and keep it relevant.
Please add this feature. My clients keep asking why they cannot do the same thing in powerbi!
Please do allow access to R from Excel. Extremely useful in Power BI but sometimes i need the same features from Excel and since Power Query seems to be "the same" it would be ideal to have access to R from both.
James Lee commented
Definitely need R.Execute functionality in Excel Power Query!
If you really really need R / Python / whatever in Excel, it's quite straightforward to roll your own. Have a look at Excel-DNA: https://github.com/Excel-DNA
There's even an example R-integration project: https://github.com/Excel-DNA/Samples/tree/master/UsingRDotNet
Kent Maxwell commented
The complexity of R didn't stop Microsoft from adding R capabilities to Power Query in Power BI. There is no reason that Power Query in Power BI should be any different than Power Query in Excel. Why?
For the love of all things holy ..... we need R scripts in excel
"The reason we’ve resisted this is because the R run-time & various packages (and updating their versions) aren’t straightforward for other users to install"
@Ashvini - All your customers are not VP's sitting in corner offices and pushing the forward button on Outlook
So don't worry about it not being straightforward for us
"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."
Since so many Microsoft apps support Open R, R should be installed and managed in one location on every desktop. The installation can be done by Windows, Office 365, Power BI, SQL Server, whatever. When an app is run, it checks for the install and version, and install/update as necessary (including packages). For the Microsoft apps that support R, other instances of R installed elsewhere should be ignored.
Add this option for R to Excel immediately.
Or even sooner.
pato lobos commented
Hi Excel Team,
Already more than 2 years and absolutely no progress! We need not only R but also Python support! How is it possible that power query in Power BI gets all the love and nothing in Excel?
Can we get an update ASAP?
Bruno Crotman commented
How is it going?
James Hinton commented
Imke Feldmann: "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?"
Will Harvey commented
It would be a huge leap for Excel if it had R and Python like Power BI Desktop.
Any progress in this?
"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"
Perhaps R Open and associated packages should be installed with Office 365. Updates can be part of Office 365 updates. Then you can add the R.Execute function to M in Excel, which would allow folks to build cross-platform solutions using M & R.
pato lobos commented
As many have said R (and Python) in Excel is an evolutionary step. I can't not tell you how important this is. I run here in Oslo the UseR! chapter and I work as IT consultant; this thing will solve so many problems and will open insights to upper management is so many fields and companies. This lack of R and Python is a big issue, you might have only 136 votes, but we are not "a regular vote" the R community is small with a massive impact worldwide, so please don't evaluate us on that. You have a comment from Imke Feldmann check her out and the positive impact she has over 10 of thousand of Microsoft user, maybe I can get on board Marco Russo and Alberto Ferrari on this one, maybe that can help ;-) ?