Forum Discussion

reidiain5's avatar
reidiain5
New Member
4 years ago
Solved

Dashboard Design

I am in the process of building a number of HR dashboards and I am keen to ensure if possible these are tailored to our different business areas. As such I wanted to ask is it possible to change the ...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi reidiain5 ,

    Here I suggest you to try Row-Level-Security to achieve your goal.

    I create a sample to show you how to create a dynamic rls data model.

    Fact Table:

    User Table:

    Logo Table:

    Relate all tables by Company column. Then create a new role in [User] by USERPRINCIPALNAME() function.

    Let's view as UserA in Power BI Desktop.

    View as is a test, RLS will work in Power BI Service.

    You need to manage security in Power BI Servcie. For reference: Manage security on your model

     

    Best Regards,
    Rico Zhou

     

    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
4 years ago

Hi reidiain5 ,

Here I suggest you to try Row-Level-Security to achieve your goal.

I create a sample to show you how to create a dynamic rls data model.

Fact Table:

User Table:

Logo Table:

Relate all tables by Company column. Then create a new role in [User] by USERPRINCIPALNAME() function.

Let's view as UserA in Power BI Desktop.

View as is a test, RLS will work in Power BI Service.

You need to manage security in Power BI Servcie. For reference: Manage security on your model

 

Best Regards,
Rico Zhou

 

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