Skip to main content

Troubleshooting Import from Analytics Cloud

The following are possible error scenarios when importing a dataset from Analytics Cloud:

Failed to load data from Analytics Cloud

There was an error loading your dataset from Analytics Cloud. This may be a momentary failure, in which case a retry should resolve the issue.

This error could also be an indication that the dataset is not configured with UTF-8 encoding. If the dataset has been created using Alteryx Designer, the encoding defaults to ISO-8859-1 Latin I, and not UTF-8 – in this case we recommend the file is initially created using UTF-8 encoding. Please refer to the section below for more information on how to select the correct encoding when uploading the dataset to Analytics Cloud.

If this error persists, please contact our support team via https://my.alteryx.com/

The source dataset contains non-UTF8 characters

When using an Analytics Cloud file-based dataset in Auto Insights, it’s important that either the dataset is saved using UTF-8 encoding, or the file encoding is correctly selected during upload so that it can be converted accordingly.

If the dataset has been created using Alteryx Designer, the encoding defaults to ISO-8859-1 Latin I, and not UTF-8 – in this case we recommend the file is initially created using UTF-8 encoding:

Designer_file_encoding.png

An alternative solution is to select ISO-8859-1 encoding when creating the dataset in Analytics Cloud, so that it can be converted to UTF-8.

To successfully convert the dataset to UTF-8 encoding for Auto Insights, select Edit settings below the data preview in the right panel when uploading files within Analytics Cloud, and then select UTF-8 and choose the appropriate encoding from the drop-down list.

aac_file_upload_encoding.png

In the above example, the source file is saved in Shift_JIS encoding. To correctly convert this file to UTF8 encoding compatible with Auto Insights, Shift_JIS is selected from the encoding drop-down in the Import Settings dialog. This dataset will then be converted from Shift_JIS to UTF-8 encoding during transfer to Auto Insights.

After configuring the encoding in the Analytics Cloud dataset settings correctly, select Re-Analyze the dataset in Auto Insights to re-trigger the dataset upload from Analytics Cloud.

There are column names in your dataset that contain the vertical bar character

Auto Insights does not support the vertical bar (pipe) character "|" within column headers. This character should be removed from all column headers in the source data and the dataset re-analyzed.

Column [X] starts with a non-numeric value

Auto Insights has detected this column (or this column has been configured) as a Date however, the data contained within this column is non-numeric which is not compatible with a date column. This column will need to be reconfigured as a Segment.

To configure columns
  1. Go to the Datasets page.

  2. Select the 3-dot icon > Configure dataset for the dataset you want to edit.

  3. The column structure for this dataset displays.

    Dataset_Settings_Columns.png
    • Dates—Indicators of time. For the Date fields please specify your Financial Year Start Month and if it should be the Default Date. Default Dates are those that Auto Insights uses as default in Missions and Search.

    • Segments—Dimensions you can break your measures down by (for example, Categorical fields such as Departments, Age Groups, Gender, or Supplier Names).

    • Measures—Fields Auto Insights can sum or aggregate (for example, numeric fields such as Sales Amounts, Quantities, Spend Amounts, and Expense Amounts). For the Measure fields, specify if this is a good thing when it increases (for example, it's good when sales increase, and not good when costs increase), and can this be aggregated over time? Most of the time it is yes unless you have something like a bank balance, where you can't sum the balance over time.

  4. Select Configure Columns to make changes to the column configuration.

    Configure_Columns.png
  5. Once you have completed your review, select Confirm Column Configuration. Auto Insights uses these changes to re-analyze your dataset.

Failed to interpret date format for column [X]

This column has been configured as a Date, and the data within this column is not compatible with the configured (or auto-detected) date format. The date format for this column will need to be reconfigured with the appropriate date format.

To configure columns
  1. Go to the Datasets page.

  2. Select the 3-dot icon > Configure dataset for the dataset you want to edit.

  3. The column structure for this dataset displays.

    Dataset_Settings_Columns.png
    • Dates—Indicators of time. For the Date fields please specify your Financial Year Start Month and if it should be the Default Date. Default Dates are those that Auto Insights uses as default in Missions and Search.

    • Segments—Dimensions you can break your measures down by (for example, Categorical fields such as Departments, Age Groups, Gender, or Supplier Names).

    • Measures—Fields Auto Insights can sum or aggregate (for example, numeric fields such as Sales Amounts, Quantities, Spend Amounts, and Expense Amounts). For the Measure fields, specify if this is a good thing when it increases (for example, it's good when sales increase, and not good when costs increase), and can this be aggregated over time? Most of the time it is yes unless you have something like a bank balance, where you can't sum the balance over time.

  4. Select Configure Columns to make changes to the column configuration.

    Configure_Columns.png
  5. Once you have completed your review, select Confirm Column Configuration. Auto Insights uses these changes to re-analyze your dataset.

An unexpected error has occurred

The data has been successfully transferred from Analytics Cloud, but an error has occurred while analyzing this data. Contact our support team via https://my.alteryx.com/ and share the unique 6-digit or 8-digit alphanumeric code that was included in the error message so it can be investigated further.

Hinweis

Note that our recommended maximum dataset size is 17GB. For more information on handling larger datasets, see What Size Data Can Auto Insights Handle?