Could you please share a bit more about the error message within your app?
Could you please show more details about the ObservationDate column in your Azure SQL table? Is it a datetime type column?
I have made a test on my side, and don't have the issue that you mentioned. Please consider take a try to re-create a new connection to your Azure SQL Table from your app, and then take a try with the following formula: