SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Missing Checkbox for Security Filter in Power BI Desktop

Just a quick blog post so that other people don’t waste 15 minutes of their life looking for a missing checkbox.
I was implementing security using roles in a Power BI Desktop model. I had defined the role along with its filter on top of a many 2 many relationship. The relationship between the fact table and the bridge table was set to “bi-directional cross-filtering” (bi-di).

When I tested the role, the dimension and the bridge table were filtered just fine, but the fact table wasn’t. I remembered I had to select a checkbox on the relationship: “Apply security filter in both directions”, because the bi-di won’t be honored in RLS scenarios. Kasper de Jonge explains it in his blog post Dynamic security made easy with SSAS 2016 and Power BI (a must-read).

Except that the checkbox wasn’t there.

checkbox security filter is missing


where is my checkbox?

So after a bit of digging, I found out that the following preview property must be enabled: Enable cross filtering in both directions for DirectQuery.

Quite confusing, since I’m not using DirectQuery at all. Anyway, once you enabled this feature – you don’t even need to restart Power BI Desktop – the checkbox is alive and kicking.

checkbox is back

And all was well. Also, Kasper said he’ll fix it. Sweet. ??

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at element61, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.


Leave a comment on the original post [sqlkover.com, opens in a new window]

Loading comments...