Gateway Hana Connection Successful but Report with Direct Query Fails.
The Gateway is run with a Domain Account with SPN set, the new Data Source Tested good and SSO box is checked, but when a Report is published using Direct Query and the exact same Hana server name, all we see are Xs instead of data.
Tried a 2nd Data Source with a different name and user credentials and got an error that it was a duplicate? What? Surely more than one user can have a connection to the same Hana Sidecar -- right?