Data schedule failed error : System.OutOfMemoryException

[Yasser005]

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]

How many result rows are expected from your scheduled query? 

[Yasser005]

900 000 rows of data... 

[DSG-Lux]

So still ok...

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