How do I resolve "no data on all visuals" errors when I send test email reports in Quick Suite?

Short description

Quick Suite email reports rely on static default parameter values to display dashboard data. When static default parameters or their linked filters don't match values in your dataset, no data appears in the visuals. This also occurs because Quick Suite ignores dynamic default parameters. When no data appears in visuals, Quick Suite can't send the email report and returns one of the following error messages:

• "Report was not sent because no data on all visuals caused by dynamic default parameter."
• "Report was not sent because no data on all visuals (User: All)), when using Static Default parameters with filters."

Resolution

Note: If you receive errors when you run AWS Command Line Interface (AWS CLI) commands, then see Troubleshooting errors for the AWS CLI. Also, make sure that you're using the most recent AWS CLI version.

To resolve the error, edit the dynamic or static default parameters and their linked filters or controls.

Complete the following steps:

1. Open the Quick Suite console.

2. Choose Dashboards, and then choose the dashboard that has the issue.

3. Note the dashboard ID from the browser URL.
   Note: The dashboard ID is the string after /dashboards. For example, https://us-east-1.quicksight.aws.amazon.com/sn/dashboards/a1bc123d-abc1-abc2-abc3-abcdefef12345.

4. Run the following describe-dashboard command to identify the dashboard's source analysis:

   aws quicksight describe-dashboard --aws-account-id ACCOUNT-ID --dashboard-id DASHBOARD-ID

   Note: Replace ACCOUNT-ID with your AWS account ID and DASHBOARD-ID with the dashboard's ID.

5. Note the source analysis Amazon Resource Name (ARN) from the output for the next step.
   Note: In the example output, the source analysis ARN is e87fc9ae-e7dd-41b0-98e4-b7246eddf8ba.
   Example output:

   {    "Status": 200,
       "Dashboard": {
           "DashboardId": "a1bc123d-abc1-abc2-abc3-abcdefef12345",
           "Arn": "arn:aws:quicksight:us-east-1:658909682992:dashboard/a1bc123d-abc1-abc2-abc3-abcdefef12345",
           "Name": "12345",
           "Version": {
               "CreatedTime": "2022-03-10T09:36:47.593000-06:00",
               "Errors": [],
               "VersionNumber": 1,
               "SourceEntityArn": "arn:aws:quicksight:us-east-1:658909682992:analysis/e87fc9ae-e7dd-41b0-98e4-b7246eddf8ba"

6. On the Quick Suite console, choose Analysis.

7. Replace the last part of the browser URL with the source analysis ARN, and then press Enter.

8. On the Controls panel, edit each control, and then note the parameter names.

9. In the navigation pane, choose Filter, and then edit each filter. Then, check the filters that use parameters.

10. In the navigation pane, choose Parameters, and then edit the parameters that you identified earlier.

11. Check if parameters have dynamic or static default values.