Forum Discussion

allan_vxcase's avatar
allan_vxcase
New Member
2 years ago
Solved

Creating and Parameterizing Roles with more scalability?

Hello, how are you? I'm wondering if there's a way to create new roles in PowerBI Desktop and parameterize them in a way that I can do it for dozens of roles nad parameters. I'm using them for RLS, ...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    allan_vxcase yes, you are making it super complicated for yourself. You can have a table with the Manager Id, Manger Email (used to access Power BI reports), and Store ID they have access to. You will add one role, where you will compare which user is currently logged in and filter these stores they have access to. Check this article for more details

parry2k's avatar
parry2k
Super User
2 years ago

allan_vxcase yes, you are making it super complicated for yourself. You can have a table with the Manager Id, Manger Email (used to access Power BI reports), and Store ID they have access to. You will add one role, where you will compare which user is currently logged in and filter these stores they have access to. Check this article for more details

allan_vxcase's avatar
allan_vxcase
New Member
2 years ago

Thank you very much! I believe this is just what I need!