trying to Implement a column security level workaround

[sang73]

Hello

I have a Procedure table that contains all exams. This table has a patient name data and I am trying to hide content column for non authorized user

to do so, I use a first parameter table: Can see sensitive data

that has 1 column: Area

and by default 2 records: Revenues, Patient name

I use roles to define what group of users can see Revenues, what other can see Patient name.

I below example, Treasury guy cannot see Patient name has it s not in the "Access to sensitive data" table

I created a proxy column Patient name to replace content depending if user can access my Patient name data

Although my test seems to work: Can See Patient name = false

my proxy patient name column is not returning "XXxxxxxxx"

any idea why ?

if my approach cannot work, any suggestion, besides transposing my column data into record to apply RLS.

[Anonymous · Accepted solution]

You cannot create a table dynamically in Power BI. All columns and tables MUST BE DEFINED IN THE MODEL before you start using it. From this stems as well that you CANNOT replace column values. Simple as that.

I don't think there's anything in Power BI like column-level security...

Best

Darek