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.

For encodeUriComponent – Use the following

encodeUriComponent(triggerBody()[‘text_1’])

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.