Problems with dates when using R Script in Power Query

[MrDataGeek]

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?

[v-haibl-msft]

@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

[v-haibl-msft]

@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

[Shivendra]

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

thanks!!!