topic Re: SSRS report subscription errors on Power BI Report Server in Report Server

SSRS report subscription errors on Power BI Report Server

micheledubose — Mon, 02 Aug 2021 03:10:42 GMT

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?

Re: SSRS report subscription errors on Power BI Report Server

Hariharan_R — Mon, 02 Aug 2021 05:05:31 GMT

Hi,

Just try the below checklist,

1. Report is running with limited data in broswer

2. Report is running with same subscription parameter values in broswer

3. If above 2 steps works then note the timings and try to run the subcription with limited value and check whether subscription is working or not

Try to create different subsctiption with different filters and combine them in excel files. we have option to configure the timeout but try do at the end after try all the above as it may impact the other report performance..

Thanks

Hari

Re: SSRS report subscription errors on Power BI Report Server

micheledubose — Tue, 03 Aug 2021 14:08:51 GMT

I've modified the query time out setting in the SSRS report's data set which fixed my issue. However, I still would like to know if there's a time out setting on the Report Server?

Re: SSRS report subscription errors on Power BI Report Server

Icey — Wed, 04 Aug 2021 03:14:40 GMT

Hi micheledubose ,

For timeout setting in Power BI Report Server, please refer: Server Properties Advanced Page - SQL Server Reporting Services (SSRS) | Microsoft Docs.

To open the setting page, try this:

start SQL Server Management Studio

→ connect to a report server instance

→ right-click the report server name

→ select Properties

→ select Advanced

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: SSRS report subscription errors on Power BI Report Server

micheledubose — Wed, 04 Aug 2021 15:30:30 GMT

If I change any of these settings, do I have to restart the Power BI service?

Re: SSRS report subscription errors on Power BI Report Server

Icey — Thu, 05 Aug 2021 02:40:28 GMT

Hi micheledubose ,

I think you are talking about Power BI Report Server, not Power BI Service.

And based on some tests, it is unnecessary to restart your Power BI Report Server after changing settings above. But it is needed to refresh the report server page to see some changes. And some settings may have some delays.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.