Row-Level Security in SSAS tabular model

Hani 21 Reputation points


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,

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.
1,242 questions
0 comments No comments
{count} votes

0 additional answers

Sort by: Most helpful