Failed to Retrieve Data From Source: Index and Length Must Refer to a Location Within the String. Parameter name: Length

We may encounter a NAV (On-Premise) SOAP data source query preview error :

Failed to retrieve data from source: Index and length must refer to a location within the string. Parameter name: length

Resolution

To resolve this error:

1. Edit the Dynamic NAV SOAP connector.
2. Mark this checkbox for Use NTLM.
3. Click on Validate and Save

4. Click on Data Souce then Bulk Source.
5. And click on Query.
6. Then Create a Bulk Query.

7. Preview the query with no error.

We must use NTLM if the NAV SOAP connection requires NTLM authentication.