cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stephlocke New Member
New Member

PowerBI Desktop (latest version) R Script component not reading data.table or dplyr tables correctly

The R script component should be able to extract all objects of the class data.frame, produced by an R script.

 

If I simply produce standard data.frame objects, it will indeed pick them all up. If however, I use one of the common packages that enhance data.frame objects like data.table or dplyr, I start getting unstable behaviour.

 

Basic data.frames:

iris1<-iris
iris2<-iris

Using data.table:

library(data.table)
iris1<-iris              # shows up
iris2<-iris              # shows up
iris3<-setDT(copy(iris)) # shows up
iris4<-setDT(copy(iris)) # doesn't show up

Using dplyr:

library(dplyr)
iris1<-iris         # shows up
iris2<-iris         # shows up
iris3<-tbl_df(iris) # doesn't show up
iris4<-tbl_df(iris) # doesn't show up

Such behaviour could be related to how PowerBI interrogates the class of the objects in the R workspace. Ideally, it should see if objects `inherits()` data.frame and extract those that do

 

 

PowerBI desktop: Version: 2.32.4307.641 64-bit (February 2016)

R: 3.2.4

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,903)