topic Re: Data schedule failed error : System.OutOfMemoryException in Report Server

Data schedule failed error : System.OutOfMemoryException

Yasser005 — Thu, 25 Jan 2018 12:53:23 GMT

Hello,

we use the Power Bi Reporting Service October 2017 and we can not create a new scheduled refresh on the power BI Reporting Service.

We got this issue:

An error has occurred

after auditing the log file , we noticed this error : System.OutOfMemoryException

We use the 14.0.600.442 Version.

Has anyone a solution for this ?

DSG-Lux — Fri, 26 Jan 2018 07:49:00 GMT

How many result rows are expected from your scheduled query?

Yasser005 — Fri, 26 Jan 2018 09:03:24 GMT

900 000 rows of data...

DSG-Lux — Fri, 26 Jan 2018 09:05:25 GMT

So still ok...

what does SQL profiler tell you when you execute the SQL query on the report server?