Report Portal

Is it possible to circumvent role-based row-level security with a well-crafted DAX query?

Recently, while discussing role-based security in SSAS Tabular models with a few colleagues, the following question came up: Is it possible to write a DAX query in such a way that row-level security is bypassed?

At the time, we all agreed that the notion seemed ridiculous.if that were possible, what's the point of even having row filters in roles? On the other hand, I'd just finished Rob Collie's (b | t) excellent book in which I learned that the CALCULATE function can be used to "remove existing filter context".


Tags: dax, tabular


2007-2015 VidasSoft Systems Inc.