Role-Based Security Issue: Incorrect Data Display for Specific Role in Power BI Without Dept filter

[IshaqAttah]

Hello,

I hope you're all doing well. I’m currently working with role-based security in Power BI and have written a DAX expression to filter data for a specific role related to the 'Tango Ltd' department:

'e2e_database InventoryDetailsMw (2)'[Department] == "Tango Ltd"

However, I’m encountering an issue where, when viewing as the role, some data unrelated to 'Tango Ltd' is still visible. Interestingly, when I apply the department filter (with 'Tango Ltd' being the only option available), the data view corrects itself and only shows the relevant information.

Could anyone kindly guide me on how to resolve this issue? I would greatly appreciate your help. Thank you in advance!

[Anonymous · Accepted solution]

Hi @IshaqAttah ,

I created a simple table and set the filter of department equals Tango Ltd in Manage Roles, and only the relevant data is displayed in the view, but I added the department column in another table, which also contains Tango Ltd data, and the irrelevant data is also displayed in the Table_4 view.

So could you please show me a screenshot of your report view, table view, and model view?

Test1:

Test2:

Table View:

e2e_database InventoryDetailsMw Table:

Table_4:

Model View:

Best Regards,

Sunshine Gu