Error: We couldn't connect to the data source. Please check your logon information. Here's the error message we got: The remote server retunred an error: (401) Unauthorized - when using odata

When trying to use the Odata link in the Microsoft Excel 2013 you may receive the following error message:

We couldn't connect to the data source. Please check your logon information. Here's the error message we got: The remote server returned an error: (401) Unauthorized.

After selecting okay on this message, you then receive this error message:

Unable to obtain list of tables from the data source.
This error message may occurr when outputting Attribute category names that begin with a number in the query you are using for Odata. This is outlined in the following article by Microsoft: https://msdn.microsoft.com/en-us/library/office/gg264773.aspx
  • Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites and we cannot assist with implementing resolutions from these websites.

Steps to Duplicate

1. Go to Analysis > Information Library > search the affected query 
2. Select the arrows to the left of the query name > select get odata link > copy the link
3. Open a blank Microsoft Excel > select the data tab
4. Select From Other sources > From OData feed
5. Paste the link in the location of the data feed
6. Enter the log on credentials
7. Select Next > Receive error message

Environment

 Altru Arts & Cultural

Was this article helpful?