Analysis Services - Dynamic filter for users not working

Question

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?

anonymous · Answer

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-tabularRegards,Lydia

arklur · Answer

I'm using Connect Live.

anonymous · Answer

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

Forum Discussion

Analysis Services - Dynamic filter for users not working

3 Replies

Related content

Cohort analysis

Azure Analysis Service Migration Scenarios

Error Querying from Analysis Services Source

Retention analysis

Gallery Terms of Service