Skip to main content

    Power BI

    New

    Change data types and other formatting functionality with SAP HANA DirectQuery

    Vote (9) Share
    Ryan Borys's profile image

    Ryan Borys on 10 Dec 2018 22:44:54

    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).

    Comments (1)
    Ryan Borys's profile image Profile Picture

    8c547f65 4479-4445-99a5-b700e7c0ad54 on 06 Jul 2020 00:10:01

    RE: Change data types and other formatting functionality with SAP HANA DirectQuery

    in addition values are not shown with decimals (but rounded) and with that the data fetched becomes incorrect. with that making the feature useless