News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP forum How to set up SSRS sub...

Microsoft Dynamics GP forum

Suggested answer

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

(0) Share

Report

Report

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:

Reporting and BI

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Joseph Markovich 3,818 on at

Like (1)

Report

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 2,992 on at

Like (1)

Report

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:

Create and Manage Subscriptions for Native Mode Report Servers - SQL Server Reporting Services (SSRS) | Microsoft Learn

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 288,768 Super User

#2

Martin Dráb 225,985 Super User

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans