Forum Discussion
Helper VApply RLS only at the drillthrough level but not on main page
thanks for the reply. I was able to do this without having two semantic models. I followed the instructions stated in the other responses to this post, and it is working.
Super UserRLS applies to the entire semantic model, not at the page level. There is no way to have RLS active on one page and inactive on another within the same report. However, you can achieve the desired behavior by using two separate semantic models:
Step 1) Semantic Model A (no RLS): contains the aggregated/main page data. All users see everything.
Step 2) Semantic Model B (with RLS): contains the detail-level data. RLS is configured using your user-country mapping table with a filter like [UserEmail] = USERPRINCIPALNAME().
Step 3) Build the main page on Model A and the drillthrough page on Model B. Use drillthrough across reports (the drillthrough target can be a separate report connected to Model B). In the Service, this works via cross-report drillthrough: on the detail report's drillthrough page, enable "Cross-report" in the drillthrough settings.
Also check the following link for the details and required setting before you follow up the steps I mentioned:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
ldwfthanks for the reply. I was able to do this without having two semantic models. I followed the instructions stated in the other responses to this post, and it is working.
v-anbandariCommunity Support
Hi ldwf,
Thank you for the update. We Glad to hear that the issue is resolved.
Please continue using the Microsoft Fabric Community Forum.
Thanks.