Forum Discussion

teolachev's avatar
teolachev
Helper II
10 years ago
Solved

R Script imports only the first dateframe

I'm testing import from R Script (beta) in Power BI Desktop. I am trying the following script using the AdventureWorksDW vTimeSeries view but only the sales dataframe shows up in Query Editor. The sales_ts table doesn’t show up. It looks like the R Source returns only the first data frame. What am I doing wrong?

 

library("RODBC")

conn<-odbcConnect("AdventureWorksDW")

#conn

sales <- sqlFetch(conn,"dbo.vTimeSeries")

#str(sales)

#sales

sales_ts <- ts(sales, frequency = 12, start = c(2005, 07))

1 Reply

  • Never mind, I got it. Only data frames are imported.