Unauthorized to access OData feed in Excel

(0) Share

Report

Posted on by Pooja Karki

3,045

Hello All,

I have created New data entity in the basis of new table and i have also set IsPublic property to yes but when I am trying to access Odata url in Excel it is giving me below error and I have doing all this by administrator login.

Error:- We couldn't connect to the data source. Please check your login information.

Here is the error message we got: The remote server returned an error:(401) Unauthorized

Please help.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Mea_ 60,284 on at

Like (0)

Report

Hi Pooja Karki,

What do you mean under "access url in excel" ? Nice and easy way is to go to Common -> Office Integration -> Excel workbook designer and generate workbook for your entity.

Was this reply helpful? Yes No
Pooja Karki 3,045 on at

Like (0)

Report

Thanks for giving idea about new option but I want to call data through OData Feed option in Excel by using OData Url and when I am doing this I am getting above error which is related to the authorization.

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Does it work if you use the Data Connector App in Excel instead of adding the feed directly? It should ask you for your AAD credentials.

And has the user permissions (in Dynamics AX) to use the data entity?

Was this reply helpful? Yes No
Pooja Karki 3,045 on at

Like (0)

Report

Hi Martin,

No it is not working and it is not asking for AAD credentials insisted of this it is showing below error and in my system internet is working fine:

Sorry We can't load the add-in. Please make sure you have network and/ or internet Connectivity. Click "retry" once you are back online.

Was this reply helpful? Yes No
Verified answer

Mahesh Ambati 105 on at

Like (1)

Report

if you are using Excel 2016 to connect OData feed follow below steps to connect using URL.

Open Excel --> go to Data tab --> New query --> From Other sources --> From OData Feed

now enter the URL and proceed further, now provide appropriate authentication details to connect data feed in AX.

Was this reply helpful? Yes No