Forum Discussion
Datamodel issue when used as Direct Query
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 !!!
2 Replies
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
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.
