Row-Level Security in SSAS tabular model

Question

Hi,

I have a SQL Server Analysis Service database (Tabular Model) which is used as a data source for power bi dashboards (On Premise).

I need to provide access to SSAS database to external users who don’t have a windows account and have already been authenticated through a Web Application.

My question is : can we use Row-Level Security in SSAS tabular model for external users ? so that every user sees only his data ?

Thank You,
Hani

Answer 1

Power BI Report Server only supports Windows Integrated Authentication out-of-the box. There is a framework for creating custom authentication providers, with a sample here.

This scenario is called Embedding for Your Customers, or "app owns data", and is supported in the Power BI Embedded cloud service.