Forum Discussion

rask's avatar
rask
Frequent Visitor
1 year ago
Solved

Implementing Dynamic Product Name Masking Based on RLS in Power BI

In my Power BI report, I have: A Products table with ProductID, ProductName, ManagerEmailand Category A Sales table with SaleID, ProductID, Region, and Revenue (many-to-one relationship with Pr...
Need Help
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    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.

    4799564.pbix30 KB
v-ssriganesh's avatar
v-ssriganesh
Community Support
1 year ago

Hi rask,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to DataNinja777 for sharing valuable insights.

 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community.