Forum Discussion

ling0028's avatar
ling0028
Frequent Visitor
9 years ago

Change data type using direct query

Hello,   We are replicating SAP tables through SLT. Date columns in SAP are stored as varchar(8) so SLT converts it on HANA using the same data type.   I'm trying to keep the direct query functi...
Need Help
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

ling0028

 

If your original DATE values have the format like MMDDYYYY (e.g. 07032016), please try to create a new column with following DAX formula. Then try to change the Data Type of this column to Date. Please refer to my following screenshot.

 

DATE = 
LEFT ( 'Change data type using direct query'[DATE_GLTRP], 2 ) & "/"
    & MID ( 'Change data type using direct query'[DATE_GLTRP], 3, 2 )
    & "/"
& RIGHT ( 'Change data type using direct query'[DATE_GLTRP], 4 )

 

Best Regards,

Herbert

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Have you guyz found any solution for this? I am stuck with the same error

  • ling0028's avatar
    ling0028
    Frequent Visitor
    9 years ago

    Hello,

     

    Sorry I was running out of time to deliver my project and didn't try Herbert's last suggestion.

     

    I ended up using the import data functionality.

     

    Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks for the reply. I tried Herbert's method but it didn't work. It seems that timeline is not working for direct connections. Only working for imported data.