Forum Discussion
Dynamic RLS does not work due to 2 relation paths that conflict with each other
- 2 years ago
Power BI is not Qlik. In Power BI you can only have one active relationship between any two tables in the data model. Review your designations of dimension and fact tables, review the arrow directions, and adjust the data model to adhere to the star/snowflake principles.
All these bidirectional relationships need to be challenged. Only use them if you absolutely must. Use CROSSFILTER in measures to overrride temporarily.
- 2 years ago
When security is concerned, avoid using many to many join. You can create bridge table to pass correct value to tables. Power BI works better with star schema.
Dynamic RLS conceptually marks a row true or false. Write DAX to mark true for a row each specific table can be alternate option.
If you want to have cross filter functionality, you can create DAX and add on individual visuals as filter to pass values from one fact to them.
Power BI is not Qlik. In Power BI you can only have one active relationship between any two tables in the data model. Review your designations of dimension and fact tables, review the arrow directions, and adjust the data model to adhere to the star/snowflake principles.
All these bidirectional relationships need to be challenged. Only use them if you absolutely must. Use CROSSFILTER in measures to overrride temporarily.