web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / power automate to down...
Power Automate
Suggested Answer

power automate to download SSRS report as PDF

(0) ShareShare
ReportReport
Posted on by 2
I have a scenario where I need to download the SSRS report from D365 and save the file to sharepoint using power automate. I found few articles online to do this by using invoke an HTTP request but to do this I need to pass the reportXML and methods used to get this are not available for me. I opened the report viewer and opened the dev tools and tried to find the CRM_Filter under form data and this is not visible. 
 
Is there any other way to get this reportxml? or Is there any other better way to run the SSRS report by passing recordid as a parameter then download PDF to save in sharepoint?
 
Any assistance will be helpful. 
Categories:
I have the same question (0)
  • Suggested answer
    11manish Profile Picture
    3,333 on at
    Yes—there are better and more supported ways than trying to extract reportxml when working with SSRS reports in the Microsoft ecosystem.
     
    What you’re trying to do
    • Run an SSRS report
    • Pass a recordId (parameter)
    • Generate PDF
    • Save to SharePoint
    reportxml is not the right approach for this scenario.
     
    Best approach (recommended)
    Use SSRS Report URL (simple & effective)
    If your report is hosted in:
    • SQL Server Reporting Services
    • or Dynamics 365 SSRS
    You can call it via URL:
     
    https://<server>/ReportServer?/ReportPath
    &rs:Command=Render
    &rs:Format=PDF
    &recordid=<GUID>

    Then:
    • Call this URL from:
      • Microsoft Power Automate
    • Use HTTP action
    • Save response as PDF to SharePoint
  • sai009 Profile Picture
    2 on at
    Hope this is a GET request

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard