Download SSRS report as a PDF with Power Automate – Part 1
In this blog, we will see how to retrieve PDF Download URL from the console using the SSRS report.
Step 1 – Create a new flow and set the trigger to Manually trigger a flow.
Step 2 – After you have your trigger, you need to add two inputs to it, Report Name and Report XML.
Step 3 – Then, add a List Rows action from the Dataverse connector and configure it to lookup the report by the Report Name.
Step 4 – Setup the report viewer – We do this using the HTTP with Azure AD connector, specifically the Invoke an HTTP request action.
Step 5 – We need to authorize our connection to use this action. If you’re using Dynamics 365 online, grab your CRM URL (including https://) and paste it in for both Base Resource URL and Azure AD Resource URL.
|Url of the request|
|Body of the request||id=report&iscustomreport=Custom Report&reportnameonsrs=Name on SRS&CRM_Filter=|
For encodeUriComponent – Use the following
Step 6 – Extract the PdfDownloadUrl from the Report Viewer page.
Let’s extract the value for PdfDownloadUrl so we can load it into another request and get our PDF. We’ll do this in 3 parts in Part 2.