topic Re: Create tables or queries with R script for further usage in Developer

Create tables or queries with R script for further usage

Adoman — Wed, 14 Sep 2016 10:05:40 GMT

Hi All,

is it possible to create tables or queries with Power BI embedded R Script and then use them with Power BI standard Visualizations?

Thx

Re: Create tables or queries with R script for further usage

v-chuncz-msft — Fri, 16 Sep 2016 06:22:42 GMT

@Adoman,

Yes, with just a few steps in Power BI Desktop you can run R scripts and create a data model, from which you can create reports, and share them on the Power BI service. See the following R script as an example.

# Create the data frame.
Emps <- data.frame(
   id = c(1:5), 
   name = c("A", "B", "C", "D", "E"),
   age = c(25, 27, 30, 26, 28), 
   start_date = as.Date(c("2011-01-01", "2012-02-02", "2013-03-03", "2014-04-04", "2015-05-05")),
   stringsAsFactors = FALSE
)

Re: Create tables or queries with R script for further usage

Adoman — Tue, 20 Sep 2016 08:30:37 GMT

It works, thank you!

Re: Create tables or queries with R script for further usage

Anonymous — Thu, 03 Oct 2019 19:42:23 GMT

I know this question has been asked and answered already. However, it doesn't really address some of other challenges when working with R in Power BI. For example, how to do create a tabular report directly in Power BI using only the data you loaded -- let's say the data was loaded directly from the database and you clicked on R under the visualizations and you added couple of fields into the R script editor. So, how do you create a table using only those fields?