cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joeytsui Regular Visitor
Regular Visitor

Share report with RLS

Hi All,

 

Im a beginner on power bi desktop, and i just create a report and set up RLS under "Manage Roles"

I view the report as the role which i assigned, and the data is correct.

 

Then i publish the report to a specified workspace, and view the report by using  the user under these roles, the data is correct.

but the user cannot edit the report to add more viuals.   so that i edit the workspace's privacy to "Members can edit Power BI content". 

 

After the privacy changed, the user can edit the report but they see all data and able to access the dataset.

May i know how can i allow user to edit the report base on RLS and don't allow them to access/download the dataset ?

 

Thanks in advance.

 

Best regards,

Joey

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Thejeswar Senior Member
Senior Member

Re: Share report with RLS

@joeytsui,

If this facility of RLS and Edit permission is required for only one person, then in such case, I would suggest that instead of creating RLS, filter the data that the user is allowed to see in Power BI Desktop and publish the report, then share him/her the report with edit permissions.

 

But this is not good if you have multiple users requiring a similar thing.

 

That's the most likely way out...

View solution in original post

4 REPLIES 4
Thejeswar Senior Member
Senior Member

Re: Share report with RLS

@joeytsui,

Well that is not possible.

 

When ever you make a user as an Admin for a workspace, then RLS won't work for that user.

Similarly if you give edit permission to a Workspace, then the RLS won't work for the reports in that workspace

 

RLS will only work for the Read Only Members of a Workspace

 

See the below link for reference

https://docs.microsoft.com/en-us/power-bi/service-admin-rls#using-rls-with-app-workspaces-in-power-b...

joeytsui Regular Visitor
Regular Visitor

Re: Share report with RLS

@Thejeswar

 

Thanks a lot.  Is there any alternative way to preform such function ? 

 

Best regards,

Joey

 

 

Thejeswar Senior Member
Senior Member

Re: Share report with RLS

@joeytsui,

If this facility of RLS and Edit permission is required for only one person, then in such case, I would suggest that instead of creating RLS, filter the data that the user is allowed to see in Power BI Desktop and publish the report, then share him/her the report with edit permissions.

 

But this is not good if you have multiple users requiring a similar thing.

 

That's the most likely way out...

View solution in original post

joeytsui Regular Visitor
Regular Visitor

Re: Share report with RLS

@Thejeswar, thanks a lot, let me try. 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 53 members 827 guests
Please welcome our newest community members: