Forum Discussion
Subscription report
- 1 year ago
Subscription available only for SSRS Report.
https://learn.microsoft.com/en-us/power-bi/report-server/compare-report-server-service
Hello, SolomonovAnton ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hi,Zemotard . I am glad to help you.
Unfortunately, if the reports you want to configure for subscription plans are interactive pbix files created by Power BI Desktop (RS), such report files are not supported for subscription in Report Server Server.Report Server only supports subscription to paginated reports (and they are paginated reports created through report builder. Report Server only supports subscription to paginated reports (and paginated reports that are created through report builder, not paginated reports created on Power BI Service).
This is due to the fact that a number of the functions provided in the report Server web portal (including Scheduled Refresh and subscription of paginated reports) are essentially operations performed by the database located on the local server (SSMS).
The SQL Server Agent is invoked locally to perform a series of database automation operations.
Paginated reports essentially work as XML files that are supported for SQL Server Agent to operate on.
However, pbix files do not support local Agent operations.
You need to be in Power BI Service to perform the subscription function for pbix files.
The pbix file does not support make a subscription on the Report Server.
Paginated reports can be subscribed:
As SolomonovAnton suggested, Power BI Report Server only supports SSRS paginated reports subscription, if you want to implement PBIX report file subscription, you need to use Power BI Service.
PBIX report files, as very interactive report files, cannot be subscribed through SQL Server Agent (Report Server Web Protal provides a series of automation work essentially through SQL Server Agent).
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.