Hiding JUST sensitive data per country

[Momie2005]

Hello all, 

I need some help on a problem , I have 3 tables Costumer and Customer-Contact with a Relationship with the CUSTID field and Users Table (with list of CUID of the users of the report) as shown in the model below 🙂

I want to hide  JUST the sensitive data (email,First name and last name) but to see the custumerID in both table based on the country of the user(using username Dax function), but when I use this Dax in the role,

I hide also the CustumerID field =>I'm loosing data 😕

This is what i want for a user Connected from ITALY => seeing all the data of the model BUT just the sensitive data(Customer_CONTACT TABLE) of the ITALY (email+NAME) and for others sensitive data Blank as he is from ITALY.

Coud you please advice ? 

Many thanks in advance

[Greg_Deckler · Accepted solution]

@Momie2005 Here is one pattern for column level security: Column Level Security - Microsoft Power BI Community.

There is also OLS that you can use in Tabular Editor but in my opinion it causes more problems than it solves.

[Anonymous · Accepted solution]

Hi @Momie2005,

Did Greg_Deckler 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

If that also doesn't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[Greg_Deckler · Accepted solution]

@Momie2005 Here is one pattern for column level security: Column Level Security - Microsoft Power BI Community.

There is also OLS that you can use in Tabular Editor but in my opinion it causes more problems than it solves.

[Momie2005]

@Greg_Deckler  many thanks I will try the Pattern and get back to you 🙂