250 votes31 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
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
ExcelBruno Crotman commented
It will be a GREAT achievement. Power Query is great for Data Wrangling. Sometimes even better than R. Its a very well built tool.
Adding the possibility to run R scritps will bring all the power of R. The tools are very complementary.
Regarding the difficulty of installing the libraries, I do not think this will be a problem. Many times the worksheets are shared but the update process is done by one of the users. Other times Excel serves as an environment to create a prototype that will be imported by Power BI. Anyway... we will manage that. Dont worry about it. This is a huge acomplishment! We will use it a lot!Bruno Crotman supported this idea ·