Create tables or queries with R script for further usage

[Adoman]

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

[Anonymous]

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?

[v-chuncz-msft · Accepted solution]

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

[Adoman]

It works, thank you!