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