cancel
Showing results for 
Search instead for 
Did you mean: 
0

Problems with dates when using R Script in Power Query

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
Comments
Super Contributor

@MrDataGeek

 

I can repro the same issue as you. I’ve reported this issue to Power BI team: CRI 26879691.

I’ll post here once I get any update about it.

 

Best Regards,

Herbert

Established Member
Status changed to: Accepted
 
Super Contributor

@MrDataGeek

 

This is a known limitation that is not going to be fixed any time soon. The workaround is to convert the date time to a primitive type (e.g. string) before sending it to into R and then convert it back in resulting table.

 

Best Regards,

Herbert

Established Member
Status changed to: Delivered
 
Frequent Visitor

I am having the same problem but Herbert's tick is worked for me now

 

thanks!!!