Forum Discussion

sm_accordion's avatar
sm_accordion
Frequent Visitor
6 years ago
Solved

e-mail subscriptions with row level security

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 e...
Need Help
  • sm_accordion's avatar
    sm_accordion
    6 years ago

    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.

sm_accordion's avatar
sm_accordion
Frequent Visitor
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

How does the subscription report look visually?

This is the simplest workaround to the issue so kudos!

  • sm_accordion's avatar
    sm_accordion
    Frequent Visitor
    6 years ago

    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.