How to Export SSRS Reports to sharepoint Office 365

jambai 6 Reputation points
2020-10-21T23:17:03.3+00:00

Hi

How to schedule SSRS subscriptions to save reports directly into a SharePoint Document Library.
SharePoint (Office 365) is running on cloud and we can't get UNC.
The Reporting Services Report server version is on 14.0 and is it is on Native mode

Any help is highly appreciated.

Thank you

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,799 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,624 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,816 Reputation points
    2020-10-22T02:14:17.383+00:00

    Hi,

    As I know there is no feature available to upload the file directly to Office 365 document library.

    One possible methods is to subscription SSRS report and save to shared folder. File Share Delivery in Reporting Services . As you don't have UNC here, so I suggest to save the file to a new created local file. Then sync it to one drive folder or upload it along with some powershell script to do the automation.

    Check this blog which shows how to do the file upload automatically : SharePoint Online Automation - O365 - Upload Your Files Remotely Using PowerShell To SPO Document Library

    regards,
    Lukas

    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.

    1 person found this answer helpful.