This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
I use RLS on two different DataSets that reside in two different Workspaces.
The goal is to use the Table from Dataset 1 in DataSet 2 with the RLS from DataSet 1.
This works perfectly fine, however it is not possible to impersonate an other user to test the RLS.
When I use show as different user and enter the email adress all visuals are broken. however when I do the same with this user in Power BI Desktop no RLS filtering takes place at all.
Nevertheless when I log in to Power Bi with the test user and look at the App, the RLS applies correct.
Therefore RLs works for the user in life but I can not test because the impersonation doesnt work.
Is this a Power BI bug?
Greetings
Sounds like a bug/incomplete feature of the composite model. You may want to raise this in the Issues section.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 13 | |
| 11 | |
| 9 | |
| 6 | |
| 5 |