Forum Discussion
RLS is showing incorrect numbers
Hi Anonymous
Thank you for the more detailed information, please try the following steps to see if they help.
1. After creating RLS roles in Power BI Desktop, use the "View as" feature to validate the RLS results.
If RLS works and the device count are displayed correctly, then verify the workspace permissions of the role members as mentioned by raji_n above. RLS roles doesn’t apply to members who are assigned to the Admin, Member, or Contributor role in the workspace. Please refer to:https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security#using-rls-with-workspaces-in-power-bi2. If it fails to validate the RLS effect using the "View as" feature in Power BI Desktop.
It is likely that the relationship between the tables and the settings of the page filters are causing the device counts to display abnormally.
In my simple test, no relationships are set up between the tables and page filtering is performed using the SubOpCo field in each of the three tables. This way the RLS I have set up seems to work correctly.If your problem still exists, please let me know how you set up the relationship between the tables and the filtering of the pages or tables.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
I would like to confirm the following with you:
- Has your RLS taken effect, but the device count numbers are not displaying correctly?
- Is the "device count for 3 applications" like "ArcTouch CC" a measure you created? Can you share the DAX for these measures?
- Can you please share some dummy data or snapshots that keep the data structure and tables relationships? Please take care to protect your data privacy.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-pn,
1. Yes RLS has been applied as pages each user don't need to see are blank but the device count is not showing correctly for their page. I.e. ArcTouch can't see the data on the other OpCo pages but the data on their page is showing incorrect numbers as the image above shows.
2. No, no measures have been used. It is simply 3 sets of data and then the tables for each application have a filter applied so only devices for that OpCo are shown.
Hi Anonymous
Thank you for the more detailed information, please try the following steps to see if they help.
1. After creating RLS roles in Power BI Desktop, use the "View as" feature to validate the RLS results.
If RLS works and the device count are displayed correctly, then verify the workspace permissions of the role members as mentioned by raji_n above. RLS roles doesn’t apply to members who are assigned to the Admin, Member, or Contributor role in the workspace. Please refer to:https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security#using-rls-with-workspaces-in-power-bi2. If it fails to validate the RLS effect using the "View as" feature in Power BI Desktop.
It is likely that the relationship between the tables and the settings of the page filters are causing the device counts to display abnormally.
In my simple test, no relationships are set up between the tables and page filtering is performed using the SubOpCo field in each of the three tables. This way the RLS I have set up seems to work correctly.If your problem still exists, please let me know how you set up the relationship between the tables and the filtering of the pages or tables.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Perfect! The tables were linked and now I've deleted the relationships, the numbers are viewing correctly! Thank you so much Jarvis 🙂