Forum Discussion
teolachev
10 years agoHelper II
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))
Never mind, I got it. Only data frames are imported.
1 Reply
- teolachevHelper II
Never mind, I got it. Only data frames are imported.