Datamodel issue when used as Direct Query

[Ganeshwar]

Hey folks!!!

I have an issue with one of the datamodel column type, when its used as a direct query in another datamodel,  some of the date/time column values are considering  as text and throwing an error in the visual though the type is Date/time in the source datamodel (am using a measure in a visual with this issued column). The same measure when used  in the main datamodel doesnt have any issue. 

*I have already tried pulling only date and used in measure but issue still persists but everything works fine in the main datamodel.

Any ideas would be highly appreciated !!!

[Anonymous]

HI @Ganeshwar,

What type of data source are you workde on? Can you please share some sample data or snapshot about these field values that stored in your database?

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Ganeshwar]

HI Xiaoxin

Data source used in main datamodel is MS-SQL -- this main datamodel is being used as direct query in other datamodel, the measure used in other datamodel is considering date/time column as text. But if i use the same measure in main datamodel it doesnt throw any error.