Paginated Report as a drill down report

Hi,

Yes you can do that.

Example :

Report A Power BI report : Global sales for all customers (for example a grid with Customer Name, Customer ID, Sales amount...)

Report B SSRS classic paginated report : Sales for one customer (detailed by year, month... etc..)

Step 1:

In report B (SSRS) add report parameter @CustomerID that filter the SSRS dataset. Add what you want to your report page : charts, grids by year etc..

Publish your report to PBRS.

Test it on PBRS portal by passing CustomerID parameter in URL.

http://<yourserver>/reports/report/<Folder>/ReportB?CustomerID=1

(1 or an other value). Just for the test 😉

Step 2 :

In Report A (Power BI Destkop RS), you need to generate an URL to the SSRS report : http://<yourserver>/reports/report/<Folder>/ReportB?CustomerID=<someValueHere>

For a simple test, just add an URL button action and enter the URL previously tested.

Press the button (Ctrl+Click within Power BI Desktop RS) and verify that your browser successfully open the URL.

You also can obtain a dynamic URL with calculated DAX measure or calculated column depending your model.

Let me know if I can give you more details.

Regards,

Denis