How do I use Data Items in PBRS?

The Data Items button provides the ability to set up a number of data queries that PBRS will then store and allow you to call up for use when required.

Data Items

  • Go to Data Items.
PBRS Home Menu
Power BI and SSRS. Data Items in PBRS

Create a new Data Item

  • Click Add.
Power BI and SSRS. Adding Data Items in PBRS
  • Enter a name for the new data item.
  • Select a DSN, provide any necessary credentials and click Connect.
Power BI and SSRS. Adding Data Items in PBRS
  • You will then be presented with the Get Values from Database module where you can build a query using the intuitive simple setup wizard, or paste in your own query in the Query field.
Power BI and SSRS. Adding Data Items in PBRS
  • Click Parse.
Power BI and SSRS. Adding Data Items in PBRS
  • Click Yes.
Power BI and SSRS. Adding Data Items in PBRS

Click OK.

Power BI and SSRS. Adding Data Items in PBRS

Power BI and SSRS. Adding Data Items in PBRS

Options

  • Allow multiples values to be returned by query: This option will separate different values.
  • Replace NULL values with the default value of (SSRS only): This option will pass multiple values into SSRS Parameters.
  • If no records found then returned the default value of: This options is to write a description for the records that will appear in blank.
  • Field delimiter (optional): The fields will be surrounded with the special characters that you desired.

The Data Item is successfully created.

Edit a Data Item

Power BI and SSRS. Editing Data Items in PBRS
  • Select a data item and click Edit.
  • You will be presented with the Get Values from Database module where you can modify the query using the intuitive simple setup wizard, or paste in your own query.
Power BI and SSRS. Editing Data Items in PBRS

Remove a Data Item

Power BI and SSRS. Removing Data Items in PBRS
  • Select a data item and click Remove.

Using Data Items

  • With the Insert Menu, you can insert data items into various fields in PBRS.
  • If you have several data items, you can use the search field to quickly locate the data item you need.