Row Level Security with SSAS Tabular Live Connection

Please sign up for the course before starting the lesson.

You can define Row Level Security in Power BI itself, However sometimes you do use SQL Server Analysis Services Tabular as the source for Power BI through Live or DirectQuery connection. SSAS Tabular allows you to create same type of Row Level Security. So it would be much better to use Row Level Security defined in Tabular from Power BI, rather than duplicating that in Power BI. In this lesson I’ll show you an end-to-end solution which contains elements below;

Power BI Live Connect to SSAS Tabular through Enterprise Gateway
Row Level Security Configuration in SSAS Tabular
Viewing the result filtered by RLS in Power BI

Back to: Power BI Essentials > Security