You can automatically save the generated document to SharePoint when:
– Scheduling Report OR
– Scheduling View OR
– Scheduling Excel Template

Please find below sample settings:

SharePoint related settings when scheduling excel template to save generated document in SharePoint:

SharePoint folder Structure with generated file:

Pre-requisite step: In RS Authentication page, ensure that you are getting “Success” status when clicking “Test SharePoint Connection” button:

(For instructions, please refer KB article: