Welcome to the Alteryx Knowledge Base

SharePoint Unified Connector: Failed to fetch data during tool configuration when using Service Principal (Certificate)
user

Created/Edited - 7/26/2026 by Clara Boo | Alteryx

Issue

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.

 

Environment
  • Alteryx Designer
    • Version >= 2025.1
  • SharePoint Unified Connector
    • Version >= 3.1.0
  • Authentication Type
    • Service Principal (Certificate)

 

Cause

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.

 

Resolution

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.

 

Additional Information
Was this article helpful?