Forum Discussion
PowerrrBrrr
4 years agoHelper III
Direct Query limitation on Time()
Hi, I have a table fetchind data using direct query and it has a timestamp column. I would like to convert the timestamp to another time zone. the way i would do it in import mode would be to create...
PowerrrBrrr
4 years agoHelper III
v-yalanwu-msft Did you bring timestamp column from a direct query table? I did the same as mentioned by you and I get error as
"OLE DB or ODBC error: [DataSource.Error] PostgreSQL: 42000: MatchExpr:getColumnNames:Unhandled column As (Function ("max", [Ident "rows.timestamp"]), Ident "a0").
"
v-yalanwu-msft
4 years agoCommunity Support
Hi, PowerrrBrrr ;
Can you share the error screenshot , and it should noted :here i create a mesure by dax.
Best Regards,
Community Support Team_ Yalan Wu
- PowerrrBrrr4 years agoHelper III