ODK Central OData refused connection to Excel

[biruk.s]

1. What is the issue? Please be detailed.
I have ODK central which is self hosted. Everything works fine except when trying to connect Excel to odk central through OData endpoints. Excel reports "404 Forbiden". I can at least see some valid response when I access the OData endpoint resources for all my forms if I use postman (the browser extension). I am guessing this is a credential issue but even after explicitly providing the credential in Excel 2016, it still is not working.

2. What steps can we take to reproduce this issue?
Setup ODK Central version:
e4221ebeb41cd6ccb0cedad0461e5b603c207339 (v2024.3.2-1-ge4221eb)
8b1de6512faa7a60c05764312caec01f5c138c42 client (v2024.3.2)
7574030f7ea8750f3837950001a5efcdeba45b92 server (v2024.3.1)
Server: Ubuntu 24.04.2 LTS
Configured with upstream ssl setup with Apache as the reverse-proxy with lets-encrypt certificate

3. What have you tried to fix the issue?
Tried to look at the central-service logs (docker logs --tail 100 central-service-1) but the logs are not that helpful. It just shows the url endpoint hit and the 404 message which is already what Excel is reporting. No detail logs are shown there (or I don't know how to get them).

4. Upload any forms or screenshots you can share publicly below.

[biruk.s]

Ok so I figured out the connection problem with Excel 2016. Strangely the connection problem will go away if you make the connection attempt from Data -> New Query -> From other sources -> From OData Sources instead of doing it from the Data -> From other Sources section (screenshot attached). These 2 have completely different dialog interfaces. But now, after a successful connection, there is another error saying that the "DataSource.Error: OData: The feed's metadata document appears to be invalid.". Not sure what the issue might be.