I would be very grateful if someone could share their knowledge or experience with SharePoint Online + OLAP. Is it possible to configure Kerberos for Power BI for SharePoint?
What we have:
- On-premises SQL Server Analysys Services with a ready cube
- SSAS uses unique permissions based on AD users and groups
We want to know if it's possible to work with this cube either in Excel Online or Power BI for SharePoint so that:
- users can refresh data right in the browsers (using Excel online or Power BI)
- user credentials are forwarded to the on-premises cube (using Kerberos or anything else)
I'm aware of the existance of Data Management Gateway, but I'm not sure if it's theoretically possible to forward users' permissions to the on-premises OLAP cube.
More background: We have recently setup Kerberos for SharePoint 2010 and Excel Services so that users can use data refresh based on their credentials and permissions. It works just fine, but our Customer has decided to move to SharePoint Online and wants "the same" solution moved there. I don't have enough argumets for or against this particular move.