Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We are trying to replicate some pretty complex filtering functionality from our current app in powerBI.
Here is a simplified version of our model:
Fact Table:
Person Dimension
Place Dimension
What we would like to do, is basically have our dimensions be filtered through the fact table, so that if user filters for placeid 1, they would only see personID 1 and 2 in the person slicer (note we have a many to many between place and person). We had originally implemented this using bidirectional filters, but eventually we started getting conflicts with row level security (we have several fact tables with shared dimensions and whenever RLS was used we would get ambigous path issues even though everything worked perfectly in PowerBI). Long story short is a consultant got involved and he recommended we remove the bidirectional relationships to get RLS to work, but now we are stuck with the filters not working the way we want. Is there another way to implement this besides bidirectional relationships? We are using PowerBI embedded. Is it possible to customize the DAX behind the filter list so we would be able to essentially paraemtize the slicer?
HI @schiznig,
Maybe you can try to add RLS filter on bridge table with conditions parameters manually look up from original tables.
If above also not help, I also not found other way to achieve RLS filter with bidirectional filter.
Regards,
Xiaoxin Sheng
When you had bi-directional filtering, did you check the box to enable security filtering in both directions as well?
Yes
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.