Change data types and other formatting functionality with SAP HANA DirectQuery
The SAP HANA DirectQuery does not support data prep features like changing data types as well as other formatting changes. Without the ability to prep the SAP HANA data with DirectQuery, there is no way to leverage SAP HANA's real-time data capability. Thus, whenever a user needs to change data, they are forced to use Import (a static data set).
in addition values are not shown with decimals (but rounded) and with that the data fetched becomes incorrect. with that making the feature useless