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:
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?