Welcome to the Alteryx Knowledge Base
Created/Edited -
Connecting to the SharePoint (Files or Lists) using a certificate for the Service Principal throws the following error during tool configuration:
Failed to fetch data
Further details of the error can be found in the com.alteryx.sharepointlist log file and this shows the following error:
[2026-07-08 09:15:22] [SharepointFiles v3.1.0] ERROR: Exception: Certificate-based authentication failed: Unable to load PEM file. See https://cryptography.io/en/latest/faq/#why-can-t-i-import-my-pem-file for more details. MalformedFraming raised
Traceback (most recent call last):
File "C:\ProgramData\Alteryx\Connectors\com.alteryx\SharepointFiles_3.1.0+win64\site-packages_common\Utilities\Microsoft\microsoft_utilities.py", line 209, in get_token_for_certificate_based_service_principal
client_assertion = create_jwt_assertion(client_id, privateKey, thumbprint, url)
File "C:\ProgramData\Alteryx\Connectors\com.alteryx\SharepointFiles_3.1.0+win64\site-packages_common\Utilities\Microsoft\microsoft_utilities.py", line 142, in create_jwt_assertion
processed_private_key = serialization.load_pem_private_key(
ValueError: Unable to load PEM file. See https://cryptography.io/en/latest/faq/#why-can-t-i-import-my-pem-file for more details. MalformedFraming
[2026-07-08 09:15:22] [SharepointFiles v3.1.0] WARNING: Retrying request due to error, attempt 1 of 3
NOTE: The unified connector log files can be found in C:\Users\<USER>\AppData\Local\Alteryx\ErrorLogs\PythonTools.
- Alteryx Designer
- Version >= 2025.1
- SharePoint Unified Connector
- Version >= 3.1.0
- Authentication Type
- Service Principal (Certificate)
The entered private key in the Private Key field is incorrect. Any mispelled word, missing delimiters or malformed PEM format will cause the mentioned error.
Please ensure the private key value starts with "-----BEGIN PRIVATE KEY-----" and ends with "-----END PRIVATE KEY-----" (without quotes).
Example of what the private key should look like with delimiters
-----BEGIN PRIVATE KEY-----
MIIEvQIBADANBgkqhkiG9w0BAQEFAASCBKcwggSjAgEAAoIBAQC4Z5fR3DrvmKyj
...
gdsVU89pGnNcMubxlvW9iWY=
-----END PRIVATE KEY-----
NOTE: The example shows only partial content of the key; it is not a valid key. The intention is to show that the key value needs to be within the BEGIN and END delimiters.
Example of what to enter in the Private Key field in Data Connection Manager (DCM)
NOTE: The DCM user interface may differ across versions. The above is from version 2025.2.