Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

0
MrDataGeek

Problems with dates when using R Script in Power Query

Submitted by 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
See more ideas labeled with:
5 Comments (5 New)
Comments
v-haibl-msft
Employee
Employee
‎11-28-2016 11:27 PM

@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

Vicky_Song
Impactful Individual
Impactful Individual
‎11-29-2016 06:47 PM
Status changed to: Accepted
 
v-haibl-msft
Employee
Employee
‎12-14-2016 06:33 PM

@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

Vicky_Song
Impactful Individual
Impactful Individual
‎12-15-2016 05:55 PM
Status changed to: Delivered
 
Shivendra
Frequent Visitor
‎07-25-2018 05:15 AM

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

 

thanks!!!

 

Idea Statuses