Forum Discussion

JohnFraser's avatar
JohnFraser
New Member
2 years ago
Solved

RLS - external roles

Hi all, first post so deep breath!   We are running a module as SaaS in Azure and I've designed a Power BI report and published it to a test workspace, then provided a walkthrough for one of our c...
external role
Identity server
RLS
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi JohnFraser ,

    For your requirements, dynamic RLS can be satisfied, first when creating a role in a Power BI report, write DAX as the user's username(), so that each user can find the corresponding user based on their own UPN, and then impose restrictions on it.

    Below is the official link could help you:

    Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JohnFraser ,

For your requirements, dynamic RLS can be satisfied, first when creating a role in a Power BI report, write DAX as the user's username(), so that each user can find the corresponding user based on their own UPN, and then impose restrictions on it.

Below is the official link could help you:

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.