Analysis Services - Dynamic filter for users not working

[Arklur]

I'm trying to create a dynamic filter for my model, using the "[UserName] = USERNAME()" filter on my model, based on this tutorial video.

My problem is that it looks like it doesn't work (the user can see all data).

(Different colors mean different users.)

I checked the user is not an admin (neither on the server nor database). I guess I'm missing something, any idea what could it be?

[v-yuezhe-msft]

@Arklur,

What mode do you use to connect to SSAS database in Power BI Desktop, import or connect live? Dynamics Row Level Security(RLS) only works in Connect Live mode. For more details, please review the following official article.

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular

Regards,
Lydia

[Arklur]

I'm using Connect Live.

[v-yuezhe-msft]

@Arklur,

I am unable to reproduce this issue. Instead of using username() function, do you get same issue when defining DAX filter in fact table to restrict permission?

Regards,
Lydia