Paginated Report as a drill down report

Hi,

You need :

- One Power BI Report : here, ReportA

- One SSRS report : here, ReportB

- SSRS Report server URL. For example http://<yourserver>/reports/

- The full report pathname to your SSRS report : http://<yourserver>/reports/report/<Folder>/ReportB

Test this URL with your default browser (IE, Chrome, Firefox, Safari).

Parameters concepts:

Parameter is an expression: <AField> <criteria> <AValue>

- AField is the fieldname. For example: CountryCode

- criteria : =, <>, >, <, <=, >=, IN ( ) ..

- AValue : a number, integer, string, representing the value your are look for.

Example : CountryCode=FR

Report B (SSRS):

Very important: Add SSRS parameter in your Report B. If you don't do that, you can't pass parameter from Power BI Report.

Example:

Add a parameter CountryCode.

Power BI report can pass parameter to SSRS report:

To pass parameters expression to SSRS, you must always use the same syntax:

http://<yourserver>/reports/<reportFolder>/ReportB?<AField>=<someValueHere> 

For example: 

http://SRVBI/reports/Analytics/GlobalSales?CountryCode=FR

Where:

- SRVBI is your server name

- Analytics : the folder

- GlobalSales: the report name (without rdl extension).

- ? : Always add the ? symbol after the report name to pass the first parameter expression

- CountryCode=FR : the parameter expression

How to pass parameter from Power BI report to SSRS report?

1. Create a measure

Create a DAX measure to concatenate the report URL with the criteria value.

Example:

GoToSSRS_URL := CONCATENATE("http://SRVBI/reports/Analytics/GlobalSales?CountryCode=", SELECTEDVALUE( Countries[CountryCode] ) )

Where Countries is the table name and CountryCode, the field name.

SELECTEDVALUE() will return the current context value.

2. Using Action in Power BI.

If you never use Action, read this: https://docs.microsoft.com/fr-fr/power-bi/create-reports/desktop-buttons 

And then? Simply use Url web action with your measure.

Before trying to pass more parameter, try just with one parameter.

In order to pass multiple criterias, use &

http://<yourserver>/reports/<reportFolder>/ReportB?<AFieldA>=<someValueHere>  & <AFieldB>=<anotherValueHere>

Regards,

Denis