Lucas de Almeida Carvalho on 17 Dec 2021 17:43:13
Today, only developers can create report subscriptions for other users of organization, but the recipient of the subscription get the report with RLS context of subscript creator, so the viewer is able to view all of the data without your RLS context.
The Idea is that developers is able to create the subscription and the recipient of this can receive the report with your RLS context applied, so He or She can view only the data allowed to your user.
Best Regards,
Lucas Carvalho
- Comments (13)
- Merged Idea (4)
RE: Create Report Subscriptions for others using recipient RLS context
For data security purposes, anyone who receives a Power BI subscription should only see the data in the screenshot and attachments for which they have access to in the underlying dataset. Currently subscriptions are based on the access of the person who set up the subscription. This could even be created as an option/toggle to either send the subscription based on the subscription creators credentials or based on the credentials of the person who is subscribed. Preferably this would also work for Groups added to a subscription where each users in the group would only receive the screenshot and attachments based on their individual credentials.
RE: Create Report Subscriptions for others using recipient RLS context
I am not added into any RLS roles and I created a subscription. But, the subscribers can see entire data as screenshots on the emails. Considering the limitation that subscriptions will run using my security context, is there a way that users will receive screenshots according to the RLS they are applied to.
RE: Create Report Subscriptions for others using recipient RLS context
In E-mail subscription, it will be very helpful if RLS is in place. It should fetch each recipient Email id as userprincipalname () and so each people will see only their eligible/permitted data when Preview Image option is turned on.
RE: Create Report Subscriptions for others using recipient RLS context
The requirement is to send user's periodical PDF reports. To support user who doesn't have a premium capacity but having a Pro license.
By implementing this idea we can able to see the filtered data in which RLS is applied in their Email attachment PDF.
When the user Email attached PDF he will be able to see only the filtered data not whole data.
RE: Create Report Subscriptions for others using recipient RLS context
when selecting the option to attach the report in PDF, the report should be filtered down as per the RLS applied.
RE: Create Report Subscriptions for others using recipient RLS context
This is a big must for a company with many sales agents who need someone to subscribe them to a report that gets delivered to their inbox with an image and embedded PDF that reflects their RLS.