SSRS report subscription errors on Power BI Report Server

MDuBose 716 Reputation points
2021-07-30T14:41:06.6+00:00

Hi,

I've created an SSRS report and published it on a Power BI Report Server web site. I've created a data driven subscription on the report. When the subscription runs, it takes a long time to complete in which an error is thrown. I've checked the ReportingServicesService log and noticed for the failed report this error, "Error occurred processing subscription: Failure writing file "my report": Report processing has been canceled by the user". It's a subscription so no person canceled it. When I try running the report, it spins for hours. So, I think the subscription is timing out due to the amount of data coming back. Is there a way to remedy this? Is there a setting on the Power BI Report Server where I can increase the timeout? Is this best practice and what's the impact of increasing the timeout setting?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,938 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,596 Reputation points
    2021-08-02T01:53:05.95+00:00

    Hi @MDuBose ,
    Are you using Power BI report server?
    You can ask for help on the Power BI forum: https://community.powerbi.com/t5/Report-Server/bd-p/ReportServer.
    Best Regards,
    Joy


    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.