cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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...

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...

joeytsui Regular Visitor
Regular Visitor

Re: Share report with RLS

@Thejeswar, thanks a lot, let me try. 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 27 members 925 guests
Please welcome our newest community members: