Auto send report

[ani_informa]

Hi 

I have a Power BI report in service with a filter Brand. There are 10 users to whom I want to send this report snap or pdf automatically as per the Brand they belong to. So if user 1 handles brand X and Y then he should get 2 report snaps i.e. one for Brand X and another for Y. Likewise if user 2 handles brands A, B and C then he should get 3 report snap each filtered with A, B and C respectively.

Is it possible/ doable in power bi service ?

[Anonymous]

Hi @ani_informa ,

Take a look at the documents about Row-level security and subscription in Power BI.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls 

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-report-subscribe 

https://docs.microsoft.com/en-us/power-bi/consumer/end-user-subscribe 

For members of a workspace with Admin / Member / Contributor roles, RLS does not take effect.

Best Regards,

Jay

[collinq]

Hi @ani_informa ,

If you are using RLS, then each person can subscribe for themselves based upon their individual report.  There is no way for you, as an administrator to send "filtered" versions of the reports as far as I know. 

If those users can't do it themselves or you aren't using RLS, then you could use this (not very fun) workaround of creating a report page for each of the reports per the filters that you want and then to create a subscription for each of those pages for the individuals.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!