Why You’re Seeing This Error
- Alteryx is trying to read data from your SharePoint list.
- The data contains characters or formatting that are not compatible with the default UTF-8 encoding Alteryx expects.
- This often happens if the SharePoint list has special characters, non-English text, or was created/edited in a system using a different encoding (e.g., Latin-1, Windows-1252).
How to Fix the Issue 1. Check Alteryx Input Tool Settings
- Encoding Option:
- If you are using the SharePoint Input tool or a connector, look for an option to specify the file or data encoding.
- Try changing the encoding from UTF-8 to another (e.g., Latin-1 or Windows-1252) if available.
2. Clean or Export the Data
- Export the SharePoint list to Excel or CSV.
- Open the exported file in Excel and save it as a new CSV, ensuring it is encoded in UTF-8:
- In Excel:
- Go to File > Save As
- Choose CSV UTF-8 (Comma delimited) (.csv)
- Use this new file as your input in Alteryx.
3. Use a Data Preparation Step in Alteryx
- If you must use the direct SharePoint connection, add a Data Cleansing tool in Alteryx to remove or replace problematic characters.
- Alternatively, use a Python or R tool in Alteryx to read the data with a different encoding.
4. Check for Special Characters
- Review your SharePoint list for any unusual or non-standard characters (e.g., emojis, accented letters).
- Remove or replace these characters if possible.
