How to apply SSAS roles to excel service while using FBA(Forms based authentication)

Question

We have an OLAP project which uses Sharepoint 2013 Excel Services to show excel files that contains external data from SQL Server Analysis Services (SSAS) cube.

Our Authentication method to login users is FBA (Forms Based Authentication) Our Goal is to show only subset of data from SSAS cube for each user based on their role which has already been defined in SSAS side. Because of using form based authentication, roles don’t apply on excel files from ssas, Any Idea?

Answer 1

We faced this problem and I recall we fixed using Kerberos delegation. We needed the actual user to be passed to SSAS in order to row filter that user. It wasn't simple though. Follow this: https://msdn.microsoft.com/en-us/us-en/library/dn194199(v=sql.120).aspx

Good luck.

Answer 2

Finally we use Customized windows authentication form to handle this topic