topic Re: Hiding JUST sensitive data per country in DAX Commands and Tips

Hiding JUST sensitive data per country

Momie2005 — Fri, 03 Dec 2021 12:44:42 GMT

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

Re: Hiding JUST sensitive data per country

Greg_Deckler — Fri, 03 Dec 2021 13:39:43 GMT

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.

Re: Hiding JUST sensitive data per country

Momie2005 — Fri, 03 Dec 2021 13:42:49 GMT

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

Re: Hiding JUST sensitive data per country

Anonymous — Wed, 08 Dec 2021 07:41:09 GMT

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