Forum Discussion

joakimE's avatar
joakimE
New Member
4 years ago

Add CAST to select in Odbc.Datasource?

Hi! I have developed a custom connector for ODBC. It all works as intended but I need to make it add a CAST around the select of fields of a certain data type.   Today, the preview of Native Q...
Need Help
joakimE's avatar
joakimE
New Member
4 years ago

Hello Anonymous,

Thanks for your valuable answer, I had totally missed out the part of the Constant override being deprecated.

 

The other link you provided, I have seen it before and managed to test some different mappings but never succeeded with selecting a DATA_TYPE that Power BI automatically interpreted as the Date/time/zone column type. Any suggestion?

 

But even though I got that working, I am fearing that the casting will still be required in the query's select statement, which I now realize will not be possible. 😕 Are there any other ways to query fold the column type casting?