e-mail subscriptions with row level security

[sm_accordion]

I have published a Power BI report with several pages.  I have set row level security with 10 e-mail addresses to 10 regions.  I want to set up a subscription such that a live link is sent daily to each e-mail address such that the recepient will be able to view the report daily only at his region.  What is the best way to go about this?

I understand that with RLS, you cannot subscribe others to a report.  I tried pinning an entire page to a dashboard, but I was unable to subscribe others to that as well due to the RLS.  

Any help would be appreciated.

[v-gizhi-msft]

Hi,

Based on my research, if the dashboard contains a tile or live page which uses the RLS applied dataset. We are not able to subscribe the dashboard to other users. See:

For your requirement, I would suggest you vote this same idea up:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34449625-subscribe-others-to-emai...

If you still have questions about subscription and RLS, please for free to let me know.

Best Regards,

Giotto Zhi

[sm_accordion · Accepted solution]

Thanks for your reply.  What I ended up doing is to publish another Power BI report that contains a hyperlink to the main Power BI report.  Then I can subscriber users to the report that contains the hyperlink, the users click on the link which takes them to the main Power BI report to which the RLS then applies.

Thanks again and I will vote up that idea.

[Anonymous]

How does the subscription report look visually?

This is the simplest workaround to the issue so kudos!

[sm_accordion]

The subscription report is basically just a nicely formatted title page with a link that says something like "click here to access the reports."  The link takes the user to another PBI report to which the RLS applies.  Seems to be working just fine.