Forum Discussion
Implementing Dynamic Product Name Masking Based on RLS in Power BI
Hello rask,
Thank you for reaching out to the Microsoft Fabric Community Forum.I have reproduced your scenario in Power BI and I got the expected behavior where:
- The default category for each manager shows the real product name.
- The additional categories (temporary access) display the product name as masked (####).
For your reference, I am attaching a sample .pbix file that demonstrates this solution end-to-end. You can open it in Power BI Desktop and test it using the “View as Role” option to simulate different managers ([email protected] or [email protected])
Best Regards,
Ganesh singamshetty.
DataNinja777 Thank you for your reply. I have created a separate Manager table as you suggested with two columns ManagerName and DefaultCategory . But regarding AccessType column, the Manager is given access to category dynamically. Its not possible to add AccessType column. For eg. In manager access table, Manager X has access to Electronics category by default. Later he is given access to Home decor and at some point later he is given access to Clothes.
Can you provide a solution for this?
Hello rask,
Thank you for reaching out to the Microsoft Fabric Community Forum.
I have reproduced your scenario in Power BI and I got the expected behavior where:
- The default category for each manager shows the real product name.
- The additional categories (temporary access) display the product name as masked (####).
For your reference, I am attaching a sample .pbix file that demonstrates this solution end-to-end. You can open it in Power BI Desktop and test it using the “View as Role” option to simulate different managers ([email protected] or [email protected])
Best Regards,
Ganesh singamshetty.