Forum Discussion
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 ...
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
Super User
Super UserMost likely you are talking about reports. Use separate reports (and likely separate workspaces) for your different audiences.