- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Security Roles
Hi,
Is there a way to create a security role that will prevent some users to view some data in a visual?
For example, I have a sales chart and have a measure called "Margin" as a tooltip. Am I able to create a security role that some people, e.g. managers, can view everything in that chart, while employees can only view the sales data chart without the "Margin"?
I tried to use Row Level Security, putting the Cost = 0 (the cost is used to create the measure "Margin", but that didn't help as it eliminates most part of the data.
Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create a separate table with maybe a single row in it with a single column, just garbage data. Now, create a role that has access to that table and a role that does not.
Now, create a check in your measure that looks at the COUNTROWS of that table. If it is BLANK, return BLANK, otherwise perform your calculation.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous ,
The suggestion of Greg_Deckler should be helpful.
Have you solved the problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create a separate table with maybe a single row in it with a single column, just garbage data. Now, create a role that has access to that table and a role that does not.
Now, create a check in your measure that looks at the COUNTROWS of that table. If it is BLANK, return BLANK, otherwise perform your calculation.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-09-2024 07:40 AM | |||
02-06-2025 10:20 AM | |||
02-11-2025 02:58 AM | |||
10-17-2024 12:15 AM | |||
07-10-2024 12:13 PM |
User | Count |
---|---|
135 | |
123 | |
83 | |
61 | |
46 |