Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

How to set up SSRS subscription to save file in SP Doc Library

(0) ShareShare
ReportReport
Posted on by
Hi there
 
I am on GP 18.5 and SSRS deployed in native mode.
 
I want to set up a report subscription and save the file in a SP Document Library.
 
Does anyone know if this is possible?
 
Thanks
Categories:
  • Suggested answer
    Joseph Markovich Profile Picture
    3,945 on at
    How to set up SSRS subscription to save file in SP Doc Library
    Hi Riaan-
     
    This is definitely possible!
     
    I'll blog about this in much more detail, but here is a high-level overview. Let me know if this is possible for you to do!
     
    Basically, you are having SSRS email an attached report to a shared mailbox. Then Power Automate monitors this mailbox, takes the attachment from the email and then saves it to a SharePoint document library.
     
    1. Get a static IP from your ISP. It is worth it in the long run anyway to connect lots of GP things to MS365 (Power BI, Teams, SharePoint, Power Apps).
    2. In the Exchange admin center on MS365, go to Mail Flow > Connectors. Set up a connector that is from Your Org to O365. You'll fill in the static IP here. 
    2. Set up SMTP in your SSRS. You'll use the SMTP server that you get from MS365 -- the domain-com.mail.protection.outlook.com one.
    3. Create a shared mailbox in MS365. Make sure to give the owner of the Flow you're going to create in Power Automate access to it.
    4. Set up the subscription in SSRS to email the report to this shared mailbox.
    5. In Power Automate, you're going to create a new Flow that monitors this shared mailbox, takes the attachment from the email and saves it to the document library of your choice.
     
    Will have all the details on my blog in a bit! https://josephmarkovich.com.
     
    Once you set this up, you'll also no longer need to fight with MFA and GP. Everything just gets sent through your organization's SMTP server from Microsoft.
     
    Joe
  • Suggested answer
    Lisa at AonC.com Profile Picture
    747 on at
    How to set up SSRS subscription to save file in SP Doc Library
    I'm not familiar with saving to SharePoint (SP).  Could you use the Destination = Windows File Share and have that point to a OneDrive location that is visible in SharePoint?

    Possible hints in this article:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 601 Most Valuable Professional

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 416

#3
Adis Profile Picture

Adis 384 Super User 2025 Season 1

Product updates

Dynamics 365 release plans