Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to set up SSRS sub...
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 Riaan77
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:
Microsoft Dynamics GP
  • Suggested answer
    Joseph Markovich Profile Picture
    Joseph Markovich 3,900 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
    Lisa at AonC.com 3,141 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans