How do I setup read-only Default Parameter values for SSRS reports in PBRS?

The Default Parameters tab allows you to set up read-only default values for specific parameters that you can then assign to any of your schedules.

Options - Default Parameters

This functionality is for SSRS reports only.
  • Go to Options.
pbrs options home
  • Select Default Parameters.
pbrs options default parameters

The Default Parameters tab allows you to set default values for specific parameters that you can then assign to any of your schedules.

Default Parameters are useful for PBRS environments where users are assigned schedules with specific parameter settings that need not be tampered with.

Creating a Default Parameter

To create a default parameter, perform the following:

  • On the Default Parameters tab, enter the name of the parameter in the Define parameter - Name field.
Power BI and SSRS. Default Parameters section in Options in PBRS
  • For the value, choose one of the following options:
    • Ignore the parameter specified.
    • Set its value to Null.
    • Set it to a value you specify in the Value field.
You can also drag and drop values from the inserts menu (i.e. date parameters or data items) into the Value field.
Power BI and SSRS. Default Parameters section in Options in PBRS
  • Once you are satisfied with the parameter name and value, click the Check mark to add it to the Default Parameter list.
Power BI and SSRS. Default Parameters section in Options in PBRS
  • Repeat steps 1-3 for the remaining parameters you wish to set.
  • Once you have finished entering in parameters, decide if you would like administrators (or those with similar admin rights) to be able to edit the default parameter values you just set.
    • If you do, check the box next to Allow Administrators to change these values on the parameters screen.
  • If you would like to apply these default parameter values to all your currently existing schedules, click Apply to Existing.
pbrs options default parameters allow
  • Click Yes.
Power BI and SSRS. Updating all schedules parameters in PBRS
  • Click OK.
Power BI and SSRS. Updating all schedules parameters in PBRS
  • Click Apply.
  • When reports are added to schedules, the parameters specified will now automatically have the default values you configured.