Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
The SharePoint connector allows you to use Service Principal for downloading and uploading files, but it requires the Sites.All permission, which gives the user access to all the Sites in the tenant. This article describes how to set it up.
View full article
The article provides steps to address the "WARNING: url:'c:\Program FIles\Alteryx\bin\Miniconda3\Common_Config\Wheels' is ignored. It is either a non-existing path or lacks a specific scheme." and the "no matching distribution found for" error when installing YXI.
View full article
Saving a workflow to Gallery fails with an error if there is a configuration issue with "On Success - Show Results to User" option in the Interface Designer window.
View full article
The article provides troubleshooting steps when "404 not found" error is encountered in Python tool.
View full article
When you try to insert a record to an Amazon Redshift table which has a column with attribute IDENTITY(seed, step), the record is inserted fine, but the value of the first column to be inserted is null instead of the value being passed into the Output Data tool.
View full article
Whenever attempting to connect HDFS to a Dynamic Input Tool, users may encounter the error: "Server root URL must be in the form "http://server:port""
View full article
Instead of displaying the error that causes Python package installation failure, Alteryx.installPackages() fails on decoding the error message.
View full article
When querying data with ROWID using Oracle OCI driver with the Input Data and Connecting IN-DB tools will result in the following errors: "You have found a bug".
View full article
When upgrading from 2021.3 to 2021.4, you may encounter SRCComposer_x64.dll module not found in Intelligence Suite
View full article
Receive error “Get Table List Error: Win32 Exception” when connecting to Databricks.
View full article
Input-Data-Tool-does-not-retrieve-all-the-rows-from-a-table-or-view-when-connecting-to-SAP-HANA.
View full article
The Dynamic Input tool with a DCM connection using the "Modify SQL Query", the "Replace a specific string" seems to be targeting the "Connection ID" attribute instead of the "Query" and the "Update a Where Clause" seems to be impacted as it does not show any WHERE clauses to update.
View full article
When using a Python-based connector (e.g. Salesforce Input, Azure Data Lake File Input), an error message referring to CERTIFICATE_VERIFY_FAILED appears. With the new releases of the connectors tools there are three additional errors that can happen and can be resolved with these steps.
View full article
This document explains the steps to export HAR files by using Chrome Developer Tools built into Designer to investigate the interface of HTML GUI SDK tools.
View full article
_CurrentField_ function does not work well if all the columns are not selected in the Table tool.
View full article
When trying to create a new dataset using PowerBi Tool, Designer shows 400 Bad Request error
View full article
Error: "Input Data (1117): Internal Error: Invalid parameter detected in function (null). File: (null) Line: 0 Expression: (null)." when pulling data from PostgreSQL
View full article