Row Level Security with SSAS Tabular Live Connection in Power BI

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 post 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

Note that this method is different from defining Row Level Security in Power BI Desktop. In fact we won’t use that method. If you like to learn more about that method read this blog post. If you are interested to learn more about Power BI, read Power BI online book; from Rookie to Rock Star.

Read rest of the blog post here: