Forum Discussion
Offline Desktop Solution and Administration?
Hi Brysonds ,
If you need to set RLS, please see the link Power BI Desktop Dynamic security cheat sheet, which described the detailed steps. Maybe it doesn't work, there are some tips to let it work and test it efficiently. You can also refer to this case .
If you would like the users have the only view permission, you can create security group , see : https://powerbi.microsoft.com/en-us/blog/power-bi-weekly-service-update-1027/, then add them to the only-view member of workspace, or share the content with them.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Amy,
Thank you for the replies, but I think you misunderstood the business case.
RLS is built in the desktop, but only works in the web once you've published the application. To my knowledge, there is no way to enforce RLS in the desktop client for end-users. So, if I create a Power BI desktop application that contains RLS and send it to someone else in the company, they will see all the data when the open the desktop file. Sure, they could select the role in the desktop to view the filtered data, but that defeats the purpose. That is the business challenge. They currently have a tool that uses RLS in the desktop file, so one desktop file can be created and shared with 10+ users and they only see their data. Power BI doesn't support RLS in the desktop, it only supports building RLS in the desktop, which is different.