Forum Discussion
Automatically send Power BI reports by email only containing end-user information? Dynamic RLS
Testing the role in Power BI desktop requires you to check BOTH the role and "Other user" and you need to specify the email address you want to test. Testing in the service only needs the role.
lbendlin thank you. I tried to use dynamik RLF
But when I set a filter on the emails in "manage roles" and then try to set the security in both directions, I'm getting an error saying that I can't. Do you know why?
But
Setting a filter to bidirectional defeats the purpose of RLS. Even if you can do it you never ever should. The RLS table needs to sit on the outer rim of your Star schema and point single direction all the way to the fact table.
lbendlin I also tried that, but it does not filter anything when I test the role in Power BI Desktop.
Right now all facts point to invoices and the lines of the invoices. I would think that the relation between invoices and the lines should be filtered in both directions, but it does not change anything in my tables.
Is the filtering incorrect?Testing the role in Power BI desktop requires you to check BOTH the role and "Other user" and you need to specify the email address you want to test. Testing in the service only needs the role.
🙈 Of course, well now I see that everything works fine 😊 I had only checked the "Other user" with the specified email address. Thank you very much 🙏