Forum Discussion
Connecting to SAP HANA
Hi Jeremy,
By adding port number to the system, the error is gone. Thanks for the suggestion.
I have a question:
If I create enterprise gateway with the help of Service Account (which has global rights to all data) on SAP HANA, where's the data security when a dashboard is shared between multiple users (business end users).
Do I have to make RLS on the dashboard when developed or when a end user refreshes or view the published dashboard will they get data that is restricted in SAP.
I'm not a super expert, however it's my current understanding that the only back end that can do a kind of pseudo-sso is SSAS via the EffectiveUserName to implement the security for the consuming user on a tabular model. It doesn't actually authenticate to the model using that user's credential like a true Kerberos SSO connection, rather still authenticates as the service account used in the gateway connection but then applies security to the given user based on their EffectiveUserName...
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-indepth/#mapping-usernames-for-analysis-services-data-sources explains more about how EffectiveUserName is used with SSAS.
To my knowledge currently, this wouldn't apply to a HANA data source. I'd make sure RLS is in place as you need for your purposes.