Power Platform Community Forum Thread Details

Hi Community,

I have been tasked with building a scheduled workflow for downloading a SSRS report (Opportunities) from our Dynamics CRM. As a baseline, I followed the suggestions/ solution here: SSRS Report Execution using Flow and used additional material from blogs and videos.

While I have been able to implement the described solution successfully, I am still only able to download an aggregated view of the report, ie. a graphical illustration of the aggregated sum/ amount of opportunities. Below that graphical illustration is a link with the caption "Show All" - clicking on this will show the individual opportunities that I would be interested in.

Default view:

View after clicking "Show All" (target view)

My question is, if there is a way to change the view of the report in my Power Automate flow so that I can save the detailed opportunities as a PDF instead of just the aggregated amount?

So far I have already tried the following:

I have used the developer tools from my browser to capture the network traffic. The information displayed in the "request" section I have included another HTTP-Request in my flow
I have tried to change the "CRM-Filter" to show a drillthrough-view
Added 156 to the target URL: /CRMReports/rsviewer/reportviewer.aspx:156, hoping this would request the subdocument
Extracted the "drill-through-URL" from the original response and tried to use that in the following steps

Unfortunately, none of these approaches were successful so far.

Does anyone know, if it is even possible to change the view of a report from aggregated to detailed within Power Automate Flow?

Any help would be greatly appreciated.

Thanks

Categories:

Building flows