SSRS Report Execution using Flow

(2) Share

Report

Posted on by MJain

2,450

Hi ,

Is it possible to pull SSRS report and execute and convert it to pdf using Flow?

Thanks

Categories:

General topics

I have the same question (1)

All responses (11)

Answers (1)

manuelstgomes 6,625 on at

Like (1)

Report

HI @ManishJain

I found another solution in the forum that might help you:

https://powerusers.microsoft.com/t5/Building-Flows/Flow-to-pull-a-SSRS-report/td-p/246958

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
Verified answer

Gayu 46 on at

Like (5)

Report

HI @ManishJain
Yes, you can convert the SSRS Report into PDF File in the Power Automate Flow by
Retrieving the PDF Download URL from the Console. You can get this URL from the Report Viewer.
Only thing here is to call the report and get the URL from the report viewer using HTTP POST REPORT VIEWER Action.

Step 1 – Create a new flow and set the trigger.
Step 2 – After you have your trigger, you need to add two variables to it, Report Name, Report PDF Data

Step 3 – Then, add a List Rows action from the Data verse connector and configure it to lookup the report by the Report Name.

Step 4 – Setup the report viewer – Do this using the HTTP with Azure AD connector, specifically the Invoke an HTTP request action.

Step 5 – Extract the PdfDownloadUrl from the Report Viewer page.

Step 6 – The start of the URL – Add a compose action for the following:

Step 7 – Length of Pdf Download URL – Add a compose action for the following:

Step 8 – Extract and convert the Pdf Download URL from the body – Add a compose action for the following:

Step 9 – Download PDF
Use */* in the Header section to avoid the JSON Error.

Step 10 – Send an Email

If I have answered your question, please mark your post as Solved.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (1)

Report

Thanks @Gayu ,

It was long back I wanted to achieve this but I dont think I need to do it now.

Was this reply helpful? Yes No
Sunilr11 2 on at

Like (1)

Report

Thank you for sharing the solution. If the report page doesn't contain the default values for some fields then how can we pass values to those fields automatically for different reports?

Thanks in advance.

Was this reply helpful? Yes No
rlewis71 15 on at

Like (2)

Report

On Step #4 - I get an error that the response in not in a JSON format?

Was this reply helpful? Yes No
AkshayShah 59 on at

Like (1)

Report

Hi Gayu,
I am apply the same in to power automate flow but in the Step - 9 i am getting error as attached.
kindly help & Thank you in advance.

Thanks,
Akshay Shah

Capture.JPG

Was this reply helpful? Yes No
waqqar_caci 3 on at

Like (1)

Report

did you manage to resolve this im getting the same

Was this reply helpful? Yes No
Kananelo 2 on at

Like (1)

Report

I am also getting this same error. Please advise if you have found a solution for this?

Was this reply helpful? Yes No
CU23050416-0 2 on at

Like (1)

Report

Hi, in this you will get the error "
you can fix this using the below approach
302 (The response is not in a JSON format) error in Power Automate for SSRS report" to fix this you can use the Do until loop

Was this reply helpful? Yes No
KaiHartmann1981 on at

Like (1)

Report

Hello everyone,

the connector "HTTP with Azure AD" doesn't seem to exist anymore.

It seems it is replaced with the connector "HTTP with Entra ID"?

What do I need to enter in URL and URI of that connector, to successfully connect to Dynamics CRM?

Do we need to configure anything in Entra ID as well?

Update: Ok, got it to work. It's just the URL to the Dynamics application in both cases, without the closing slash.

Now I get the 404 error "The response is not in a JSON format." at step #9

Update 2: Ok, got that solved by replacing \u0026 with & in step #9.

Now I get a JSON back, which contains the PDF as Base64.

What I still don't get is where the ReportXML for the parameter 'CRM_Filter' is coming from. Can anybody help?
Figured it out, it's the Report PDF Data from the beginning; a Fetch-XML you can also get from inspecting the rendered report in the browser...

Was this reply helpful? Yes No