Forum Discussion
PBIRB Subscription to Folder
- 3 years ago
This does address your question. If you look at the link for delivery extensions you can see that report server supports both file shares and email subscriptions https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/subscriptions-and-delivery-reporting-services?view=sql-server-ver16#bkmk_delivery_extensions
Note that this only works in the on-prem Report Server, you cannot send reports to a file share from the cloud service, but if you are using the cloud service you could use Power Automate to send files to a One Drive location
Creating subscriptions is a not a function of Report Builder, that option is available on Report Server portal once you publish the report. For more information see Subscriptions and Delivery
Also, please note that the option to subscribe reports is only available for paginated report and not for reports developed using Power Bi Desktop.
- Anonymous3 years agoNot applicable
Thank you for the response, but this does not address my issue. I'm aware of the ability to set up subscriptions on the Report Server. I'm asking about the ability to set up subscriptions to folders instead of users.
- d_gosbell3 years agoSuper User
This does address your question. If you look at the link for delivery extensions you can see that report server supports both file shares and email subscriptions https://learn.microsoft.com/en-us/sql/reporting-services/subscriptions/subscriptions-and-delivery-reporting-services?view=sql-server-ver16#bkmk_delivery_extensions
Note that this only works in the on-prem Report Server, you cannot send reports to a file share from the cloud service, but if you are using the cloud service you could use Power Automate to send files to a One Drive location
- nganguyensyntax2 years agoFrequent Visitor
To use Power Automate, the reports (either built in PBI Desktop or PBIRB) must lie inside a premium capacity? can we automate exporting reports to pdfs with Pro license or PPU? Thanks