Validating data modules

Use the validation feature to check for invalid object references within a data module.

Validation identifies the following issues:

  • A table or column that a data module is based on no longer exists in the source.
  • A calculation expression is invalid.
  • A filter references a column that no longer exists in the data module.
  • A table or column that is referenced in a join no longer exists in the data module.

About this task

Automatic and manual data module validation is available. Automatic validation is turned on by default. You can disable automatic validation, and manually start the validation when required.

With automatic validation, the results are refreshed after each update of the data module.

Procedure

  1. In the application bar, or in the Data module panel, click the validation icon Icon representing validation view. You can also click Validate from the data module context menu.

    The validation pane opens.

  2. To enable or disable automatic validation, click the Automatic toggle switch. To validate the data module manually, click Validate.
  3. Check for validation errors.

    The failed validation icon Icon representing failed validation is displayed in the data module tree and in the diagram, next to the column where the error is discovered.

  4. Click the error icons to view the number of errors and the details about the errors.

    The errors are listed in the Validation issues panel.

  5. View the error messages by clicking the Details link for each issue.

    To copy the error messages to the clipboard, click the copy Copy validation messages icon.

  6. Using the validation messages, try to resolve the errors.

    You can save the data module with validation errors, and resolve the errors later.