Forum Discussion
Direct Query for Power BI Datasets cannot display visuals for one of the datasets for App viewers
Hi dcao
Yes you can deploy RLS to the datasets. The Row Level Security needs to be set in Power Bi desktop though.
Hey Amine,
Yes, but what I meant was that I'm connected to 2 power bi datasets.
However, one of that datasets is giving blank visuals for users with view permission to the app.
If I give them access to the workspace as members, then the visuals work. I don't know why, but I don't want that because now RLS will not work because they're member of the workspace
Hi, dcao
Maybe you just forgot to manage security on your model .
Datasets->Security->Row-Level Security-> select one of the 'role' you create on PowerBI Desktop -> enter the Members' email addresses to assign the role
For more details , please refer to this document.
If you are using Dynamic RLS ,please recheck your \userprincipalname formats.
RLS-working-with-desktop-but-not-on-service-after-publishing
using-the-username-or-userprincipalname-dax-function
Best Regards,
Community Support Team _ EasonI don't think you guys are understanding my issue.
The problem is that I have reports connected to 2 power bi data sets ( Direct Query for Power BI Data Sets). My users have view access to the App. The visuals from 1 of the power bi datasets are not showing up in the service, but if I give them access to the workspace as memebers, then the visuals show up fine.
However, I don't want them to be members of the workspace. I just want them to have view access to the app.
