0 Kudos

Problems with dates when using R Script in Power Query

Status: Delivered
by MrDataGeek Frequent Visitor on ‎11-27-2016 01:41 PM

When I pass a dataframe to R from Power Query I run into a problem with dates. For instance if I pass a dataframe that represents a Date table to R using the following script:

 

    new_dataset <- dataset

 

The date field is returned as follows:

 

 

ScreenCapture.PNG

 

My goal was to pass a Date table to R and add some attributes to the Date table using R. But when I pass a Date table to R the dates are replaced with "Microsoft.OleDB.Date". Any idea what's causing this problem? What are the known issues with the R integration in Power Query?

 

Status: Delivered
Idea Statuses