OData Connection: Error: The payload kind 'ServiceDocument' of the given data feed is not supported

After upgrading to 4.0 Service Pack 10, reports based on OData connections to BBCRM queries now have a broken connection after the upgrade. You are able to create NEW connections, but refreshing existing connections returns the error message: The payload kind 'ServerDocument' of the given data feed is not supported. 
We are currently evaluating this issue for a fix in a future release. In the meantime OData Links can be manually restored.
  1. Navigate to BBECRM > Analysis > Open a Query that corresponds to the desired Excel Workbook.
  2. Click on “Get OData Link” and copy the link.
  3. Open the Excel Workbook that is related to this Query.
  4. Click on the Data tab at the top of Excel.
  5. Click “From Other Sources”
  6. Click  “From OData Feed”
  7. Paste the link from Step 2 in the “Link or File” field.
  8. Click Next and continue the setup as desired.
  9. Click Finish and the Query will populate the workbook.


 

Steps to Duplicate

1) From analysis functional area click Information Library 
2) Search for the Query
3) Click the link "Get OData link" 
4) Copy Link 
5) Open a new Excel File 
6) Select the Data tab
7) Click "From Other Sources" 
8) Select From OData data feed. 
9) Paste the OData link from step 4 
10) Select Refresh All 
 
11) Upgrade the installation to Version 4.0 Service Pack 10 
12) Open the Excel File from step 5 
13) Select the Data tab 
14) Click Refresh All 
15) Receive the error: The payload kind 'ServerDocument' of the given data feed is not supported. 

Environment

 Blackbaud CRM
 4.0
 4.0.168.0

Was this article helpful?