PowerBI adds support for R

[This article was first published on Revolutions, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

In the latest update released on November 20, PowerBI has added support for R. The desktop edition of Microsoft’s data visualization and reporting tool now allows you to run an R script to generate data; the resulting data frames from the script can then be used for data visualization or any other activities within Power BI.

This PowerBI Support article provides the details. Simply select the new “Execute R Script” option within the Other section of the “Get Data” dialog, and paste in the R script you want to run.

PowerBI screenshot
Any dataframes generated by the script (and there can be more than one) become available data sources for further PowerBI operations. PowerBI Desktop can use any R version you have installed on the local machine, including Revolution R Open.  You can see an example of using R as a data source in the video below:

 

Power BI Support: Running R Scripts in Power BI Desktop (Beta)

To leave a comment for the author, please follow the link and comment on their blog: Revolutions.

R-bloggers.com offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)