Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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.

224 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)

We’ll send you updates on this idea

Secret Stash shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

Hi folks,

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.

thanks

Ashvini Sharma
Lead Program Manager
Excel

30 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Signed in as (Sign out)
Submitting...
  • Sam commented  ·   ·  Flag as inappropriate

    "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."

    Don't worry about us - We will manage.

    Its this worry that gave us the ribbon in 2007 - and you thought it helped

  • Anonymous commented  ·   ·  Flag as inappropriate

    I don't know if this will make sense, but I prefer to have the option to use R with my queries even if I will not be able to share those queries.

    Also keep in mind that users will adjust over time when they feel this is something useful for them.

  • Anonymous commented  ·   ·  Flag as inappropriate

    A blog post mentioning R.Execute & Power Query got me all excited to use R to do things like unzipping a datafile as part of the script. But I quickly discovered that was for Power BI only, not Power Query in Excel. Shucks.

  • pato lobos commented  ·   ·  Flag as inappropriate

    You have the R script in Power BI, why not here? Maybe you want to change it to Run "ML Script", so you can Call Python, R, AzureML, etc but please MAKE EXCEL GREAT AGAIN and pull R Scripts.... (I'm talking obviously about Power Query in Excel)

  • Anonymous commented  ·   ·  Flag as inappropriate

    I would love to see both R and Python integrations given the direction of the data science community. But like others have mentioned, if its already in PowerBi, then it should be 'easy' to release it in Excel.

  • Yury Yafimau commented  ·   ·  Flag as inappropriate

    Not bad. Not sure it will be ever done. The feature is likely to change Excel like Pivot table did in the past.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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.

2 Next →

Feedback and Knowledge Base