I do see question frequently coming in community that connecting to HANA HTTP using Analysis Office 2.x, you get an error “Remote server returned an error:(403) Forbidden“.
Follow below Steps to resolve this issue
You need to Import Delivery Unit “AHCO_INA_SERVICE.tgz” from Server
Add the “INA_USER” role to the user Under “Granted Roles” section
Add the Object Privileges “_SYS_BI” , “_SYS_BIC” & “_SYS_RT” to the user, and enable checkbox “SELECT” option for those objects
These steps will helps you to resolve from err “403”
Thanks & Regards,