Blog Post

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

Ehrm.

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. ??

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating