Manage Data Blocks in Report Builder

You can view and manage all data blocks in a workbook using the Data Block Manager. The Data Block Manager provides search, filter, and sort capabilities that allow you to quickly locate specific data blocks. After selecting one or more data blocks, you can edit, delete, or refresh the selected data blocks.

The Data block manager screen.

View Data Blocks

Click Manage to view a list of all data blocks in a workbook.

The Manage option to view a list of all data blocks.

The Data Block Manager lists all data blocks present in a workbook.

The list of all data blocks present in a workbook.

Sort the Data Blocks list

You can sort the data block list by a displayed column. For example, you can sort the data block list by data views, Filters, Date Range, and other variables.

To sort the data block list, click a column heading.

Sorting the data blocks.

Search the Data Block list

Use the Search field to locate anything in the data block table. For example, you could search for metrics contained in the data blocks or data view. You can also search for dates appearing in the date range, date modified, or last run date columns.

Using the Search field to locate anything in the data block table.

Edit Data Blocks

You can edit the data view, date range, or the filters applied to one or more data blocks.

For example, you can replace an existing filter with a new filter in one or more data blocks.

  1. Select the data blocks that you want to update. You can select the top-level check box to select all data blocks or you can select individual data blocks.

    The pencil edit icon

  2. Click the edit icon to display the Quick edit window.

    The Quick edit window

  3. Select a filter link to update data views, date ranges, or filters.

    The Add Segment field in the Quick edit window

Refresh Data Blocks

Click the refresh icon to refresh the data blocks in the list.

Refresh icon

To verify if a data block is refreshed, view the refresh status icon.

A successfully refreshed data block displays a checkmark in a green circle: Green circle with check mark icon .

A data block that has failed to refresh displays a warning icon: Red triangle with exclamation mark icon .This makes it easy to identify if any data blocks have errors.

Data block manager showing refresh status for each data block listed.

Delete a Data Block

Click the trash can icon to delete a selected data block.

Group Data Blocks

You can group data blocks using the Group by drop-down menu or you can click a column title. To sort data blocks by column, click the column title. To group data blocks by groups, select a group name from the Group by drop-down menu. For example, the screenshot below shows data blocks grouped by Sheet. It shows data blocks grouped by Sheet1 and Sheet2. This is useful, for example, in the filter-replacing use case. If you have multiple filters applied to each data block, it is helpful to create a group containing all the data blocks that you want to replace. Then you can easily select and edit them all at once.

Data block manager showing the Group by Sheet list.

Modify the Data Block Manager view

You can modify which columns are visible in the Data Block Manager window.

Click the column list Column list icon icon to select which columns are listed in the Data Block Manager. Select a column name to display the column. Deselect the column name to remove the column from view.

Data block manager showing the column list

recommendation-more-help
080e5213-7aa2-40d6-9dba-18945e892f79