Error: Cannot connect to the specified feed. Verify the connection and try again (401) Unauthorized - when using oData in Query

When using the oData connection string from an Ad-hoc Query in CRM in Microsoft Excel 2010, users may receive this error when generating pivot tables:Cannot connect to the specified feed. Verify the connection and try again. Reason: The remote server returned an error: (401) Unauthorized.

Article
Number:91311

Products:

Blackbaud_CRM

In Microsoft Excel when configuring the oData connection string, use the Advanced button to change Integrated Security to "Basic"

Enter your Blackbaud CRM user name and password

Click OK.

Was this article helpful?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!

We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.

We’re sorry to hear that. Please tell us why.

I don't like how this works.

The answer is confusing.

The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.