Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
akj2784
Post Partisan
Post Partisan

R for Power BI

Hi All,

 

I want to use R for Power BI. Just wanted to check which one is better Microsoft R Open or R Studio ?

Is there any advantage considering Microsoft R Open is Microsoft's product and Power BI too.

 

Regards,

Akash

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

Hi akj2784,

 

Microsoft R Open can’t be compared with R Studio directly because Microsoft R open is the enhanced distribution of R, not the IDE. Please refer to: Microsoft R Open .

 

Currently, power bi support external IDE like R Studio and Visual Studio 2015 with R Tools for Visual Studio. Please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-r-ide.

 

In addition, R Studio is a lightweight IDE compared with Visual Studio because Visual Studio also support other languages. So if you are only using R, R Studio is recommended.

 

Regards,

Jimmy Tao

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

Hi akj2784,

 

Microsoft R Open can’t be compared with R Studio directly because Microsoft R open is the enhanced distribution of R, not the IDE. Please refer to: Microsoft R Open .

 

Currently, power bi support external IDE like R Studio and Visual Studio 2015 with R Tools for Visual Studio. Please refer to: https://docs.microsoft.com/en-us/power-bi/desktop-r-ide.

 

In addition, R Studio is a lightweight IDE compared with Visual Studio because Visual Studio also support other languages. So if you are only using R, R Studio is recommended.

 

Regards,

Jimmy Tao

So does PBI Desktop work with Visual Studio 2017?   It does not seem to detect IDE on the R Scripting Option page.  

These two .exe files do not work as "Other" when I click the up to the right arrow when editing a new R visualization:

  • C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\Extensions\Microsoft\R Tools for Visual Studio\Microsoft.R.Host.exe
  • C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\Extensions\Microsoft\R Tools for Visual Studio\Microsoft.R.Host.Broker.Windows.exe

R Tools for Visual Studio were just loaded.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.