Restricting users to see only certain values in one field

[bennisteges]

Dear community,

I have build a dashboard which shows real estate objects for different companies. Some of the fields are GDPR relevant and therefore should be restricted to some users.

One option would be to not show the entire field if user is not allowed to see sensitive fields, however, the best option I would like to go for would be to show the user all sensitive information for objects which are from his company, but restrict him from sensitive information from other objects.

So it would look something like

Object Name	GDPR relevant data / sensitive data	Non-sensitive data
Object 1	Info 1	Info 4
Object 2	Info 2	Info 5
Object 3		Info 6

(in object name object 3 / field sensitive data is data, but he is not allowed to see it, so its empty)

Is this possible?

Many thanks and best,

Benjamin

[v-pgoloju]

Hi @bennisteges,

Just a gentle reminder  has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar

[v-pgoloju]

Hi @bennisteges,

Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar

[bennisteges]

I will have a look at the proposed solution this week and come back to you. However, from the first tests I was not able to restrict data within a data field for certain users. Only entire data fields.

[v-pgoloju]

Hi @bennisteges,

Thanks for the update. Just a gentle reminder if you had a chance to revisit the issue and the provided solution worked, we’d really appreciate it if you could mark it as the Accepted Solution. If you found a different fix, feel free to share that as well.

And if you’re stuck at any point or facing a different challenge, please don’t hesitate to let us know we’d be happy to assist further. Closing the loop helps others in the community who might be facing similar issues.

Thank you & regards,
Prasanna Kumar

[v-pgoloju]

Hi @bennisteges,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution — it helps others who might face a similar issue.

Warm regards,

Prasanna Kumar

[v-pgoloju]

Hi, @bennisteges,

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful — this will benefit others in the community as well.

Best regards,

Prasanna Kumar

[miTutorials]

Check out this video on how to set up row level security !!

Create Row Level Security (RLS) to restrict access in PowerBI | MiTutorials

[Akash_Varuna · Accepted solution]

Hi @bennisteges 

Yes, it is possible to restrict sensitive data in Power BI. Create a User Access Table mapping users to their allowed companies and implement Row-Level Security (RLS) using USERPRINCIPALNAME(). Use a calculated column or measure to display sensitive data only for the user’s company and leave it blank otherwise. Replace the sensitive field with this measure in your visuals for controlled access.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance

[bennisteges]

hi @Akash_Varuna, is there a possibility to prevent creating user access table and use the current access structure from PowerBI (service) as I would like to prevent adding users to this table everytime a user gets access to my PowerBI dashboards. Thanks and br, Benjamin

[Akash_Varuna]

@bennisteges Yes, you can avoid creating a user access table by leveraging existing access structures in Power BI Service. Use Azure AD groups with Row-Level Security (RLS) roles for dynamic access control. Utilize USERPRINCIPALNAME() in measures or calculated columns to filter sensitive data based on the user's company.