Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

DirectQuery to OracleDB Formatting Data Type Text to Date

Hey everybody,    I'm using a DirectQuery to an Oracle Database, and I want to convert one of my columns from the Data Type: Text (at the moment the fields are strings in the format"6/09/2016"), to...
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    Anonymous

     

    In Power BI Desktop, the Direct Query mode only takes the source data type, and you can't change the data type under this mode. So in this scenario, you have to convert the text column into date column on Oracle side.

     

    update Table set Date_Date = to_date(Date_Text, 'D/MM/YYYY');

    Regards,

     

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

Anonymous

 

In Power BI Desktop, the Direct Query mode only takes the source data type, and you can't change the data type under this mode. So in this scenario, you have to convert the text column into date column on Oracle side.

 

update Table set Date_Date = to_date(Date_Text, 'D/MM/YYYY');

Regards,