Apply Row Level Security on subscription email

[Anonymous]

We have a number of external users that we want to share our reports with, in PDf format by subscribing them to our report, which is possible. However, we want to apply Row Level Security to the subscribed email. I am not sure how we can link their email address with the Row Level Security and distribute the PDF so they will be limited to certain parts of the reports, filtered by Row Level Security. I know that we can achieve this through Azure Active Directory B2B but this is not ideal as they don't have a Power BI Pro licence and assigning them to our license could cost us a significant amount of money. Can anyone give me any suggestion on how we can achieve this? 

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

I'm afraid it cant be realized directly.

But you may check the workaround below:

https://community.powerbi.com/t5/Desktop/e-mail-subscriptions-with-row-level-security/td-p/869918

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous , I doubt that possible with pro. With embedded power bi you will able to share reports on the portal.

You might like to R, Python or power automate for that

https://owlcation.com/stem/How-to-Export-Data-from-Power-BI

[Anonymous]

Hi @amitchandak, am not able to access the link. Could you please send me if you have an alternative one?