Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.