Share via

Row-Level Security in SSAS tabular model

Hani 21 Reputation points
2020-11-22T12:28:51.637+00:00

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
0 comments
Answer accepted by question author
  1. David Browne - msft 3,851 Reputation points
    2020-11-22T19:00:52.36+00:00

    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.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.