Latest Value based on date column in string format in DirectQuery

Hi,   I am using the DirectQuery connection to access a database that collects in real-time the battery level of a device.   I want to be able to show the latest battery value from the 'Battery' ...