Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions

© Reza Rad 2018

Reza RadPro Power BI Architecturehttps://doi.org/10.1007/978-1-4842-4015-1_19

19. Row-Level Security with Analysis Services Live Connection

Reza Rad¹ 

(1)

Meadowbank, Auckland, New Zealand

 

You can define Row-Level Security in Power BI itself (Chapter 16), However, sometimes you do use SQL Server Analysis Services Tabular as the source for Power BI through the Live connection. SSAS Tabular allows you to create the same type of Row-Level Security. In situations that SSAS Live connection is used, 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 chapter you’ll learn an end-to-end solution.

Note that this method is different from defining Row-Level Security ...