Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Scheduled emails that respect RLS

I have a report that works properly with RLS, every time a user enters the report they can only see what is linked to their email address. The agents need to see a daily report of their cases so ...
VijayP's avatar
VijayP
Community Champion
3 years ago

Syndicate_Admin 

For power bi subscriptions the static image goes as per the Original owner's subscription on image and email body!

However the report to the link will show only required information!!

 

Copied below text from the link 

https://learn.microsoft.com/en-us/power-bi/collaborate-share/end-user-subscribe?tabs=creator

Row-level security (RLS)

  • For Power BI reports, dashboards, or paginated reports that use a dataset with row-level security (RLS), use caution when creating subscriptions for yourself and others. Power BI will warn you that the data contains RLS, but customers often scroll past the warning message.

    The static image sent in the subscription email will display data based on the owner of the subscription. For this reason, when creating subscriptions, be careful to ensure that confidential information isn't included in the static image. Other than that static image, the report or dashboard itself will open (or not) and display data based on the user's permissions.