topic Re: Mass subscriptions possibility for a Report server reports in Report Server

Mass subscriptions possibility for a Report server reports

SandhyaraniDell — Wed, 04 Sep 2019 09:18:46 GMT

Hello Team,

My Business expectation is "Mass subscriptions for a Report server reports".

Do we have option to subscribe power bi report server reports by using report level filters which should be applied during the subscription creation time?

Note : Each susbcription will be having different input for a filter.

Thanks,

Sadhya

Re: Mass subscriptions possibility for a Report server reports

d_gosbell — Wed, 04 Sep 2019 21:40:28 GMT

Yes you can do this. It is known as a Data Driven Subscription and basically allows you to configure a database table with a list of email addresses and a different set of parameters for each address. See the following documentation for details on how to set these up https://docs.microsoft.com/en-us/sql/reporting-services/subscriptions/data-driven-subscriptions?view=sql-server-2017

Re: Mass subscriptions possibility for a Report server reports

SandhyaraniDell — Thu, 05 Sep 2019 08:12:36 GMT

Hi,

Thanks for your response.

I aggree that, it will be possible for SSRS reports not for the Power BI reports.

Coudl you please suggest me the way to meet my requirement for on premises power bi reports.

Thaks,

Sandhya

Re: Mass subscriptions possibility for a Report server reports

d_gosbell — Thu, 05 Sep 2019 08:35:04 GMT

SandhyaraniDell wrote:

Coudl you please suggest me the way to meet my requirement for on premises power bi reports.

This is currently impossible with pbix reports on premise. If you want subscriptions on premise the only option is to build the reports as paginated reports.

Re: Mass subscriptions possibility for a Report server reports

SandhyaraniDell — Mon, 09 Sep 2019 14:10:11 GMT

Thank you for your response.