Pass a report parameter in a URL for a paginated report in Power BI

You can pass report parameters to a report by including them in a paginated report URL. All query parameters can have corresponding report parameters. Therefore, you pass a query parameter to a report by passing the corresponding report parameter. You need to prefix the parameter name with rp: for Power BI to recognize it in the URL.

Report parameters are case-sensitive and use these special characters:

  • A space in the parameter portion of the URL is replaced with a plus sign (+). For example:


  • A semicolon in any portion of the string is replaced with the characters %3A.

Browsers should automatically perform the proper URL encoding. You don't have to encode any of the characters manually.

To set a report parameter within a URL, use the following syntax:


For example, to specify two parameters, "Salesperson" and "State", defined in a report in your My Workspace,you'd use the following URL: 

To specify the same two parameters defined in a report in an app, you'd use the following URL: 

To pass a null value for a parameter, use the following syntax:


For example:


To pass a Boolean value, use 0 for false and 1 for true. To pass a Float value, include the decimal separator of the server locale.


If your report contains a report parameter that has a default value, and the value of the Prompt property is false (that is, the Prompt User property isn't selected in Report Manager), then you can't pass a value for that report parameter within a URL. This provides administrators the option of preventing end users from adding or modifying the values of certain report parameters.

Additional examples

The following URL example includes a multi-value parameter "Salesperson”. The format for a multi-value parameter is to repeat the parameter name for each value. 

The following URL example passes a single parameter of SellStartDate with a value of "7/1/2005", for a native mode report server.

Next steps