Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
96 | |
90 | |
81 | |
69 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |