cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thracian Regular Visitor
Regular Visitor

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 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
thracian Regular Visitor
Regular Visitor

Re: R Script imports only the first dateframe

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

1 REPLY 1
Highlighted
thracian Regular Visitor
Regular Visitor

Re: R Script imports only the first dateframe

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