Forum Discussion
Need Help: Dynamic RLS in Direct Query shows no records
Hello Power BI Community, I am trying to implement Dynamic RLS using Direct Query and facing issues with filtering the dataset based on the USERPRINCIPALNAME. I have prepared a mock dataset to rep...
I am not sure if this will help.
It happened to me recently when I was setting up my RLS for DirectQuery models. Similarly, the RLS worked in import mode but does not work in DirectQuery.
Ensure that you have:
- Shared the dataset with your users under Manage Permissions
- Adding affected users into Security in Semantic Model
- Added the users into your workspace as Viewers (this was what worked for me and i missed out. When I setup my RLS on Import Mode, my users were using APPs to access the dashboards, and I did not have to add them into my workspace as "Viewers" for RLS to be effected"