March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 colour and logo design within a global dashboard if a user has access to a single line of business as a filterable option, or if someone has access to a global verson and they select a particular line of business for example the format changes to reflext logo's and formatted styles?
Solved! Go to Solution.
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.
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.
Most likely you are talking about reports. Use separate reports (and likely separate workspaces) for your different audiences.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
92 | |
91 | |
79 | |
49 |
User | Count |
---|---|
160 | |
144 | |
103 | |
72 | |
55 |