Reply
avatar user
Anonymous
Not applicable

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!

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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...

View solution in original post

3 REPLIES 3
v-piga-msft
Resident Rockstar
Resident Rockstar

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Greg_Deckler
Super User
Super User

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...
avatar user
Anonymous
Not applicable

This is helpful. Thank you @Greg_Deckler !

avatar user

Helpful resources

Announcements
March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)