PowerBI adds support for R

November 23, 2015
By

(This article was first published on Revolutions, and kindly contributed to R-bloggers)

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 on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...



If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.

Sponsors

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)