Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Web Services to Excel ...
Small and medium business | Business Central, N...
Suggested answer

Web Services to Excel Error: The odata.context URL is invalid

(0) ShareShare
ReportReport
Posted on by James De Filippo 80

Hi All,

Since yesterday, we appear to be getting a consistent error when using OData Web Services from BC to Excel.

If we are to Browse Excel > Data > Get Data > Other sources > From Odata Feed and specify any of the Web Services from BC, we encounter the same error consistently.

See below screenshot:

pastedimage1623923339083v1.png

Has anyone else encountered this recently? Looked online and the only suggestion that related to our scenario suggested clearing of the cache.

This was actioned but the issue is not resolved.

Please advise!

Thanks

James

  • Alex_Ste Profile Picture
    Alex_Ste 124 on at
    Web Services to Excel Error: The odata.context URL is invalid
    Hi James, any news about this problem, I get exactly the same error ...
    Any solution?
    Many thanks
    Alessandro 
  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Web Services to Excel Error: The odata.context URL is invalid

    Hello,

    Feel free to raise it to Microsoft via your partner or CSP so we can look into it.

    Thanks.

  • James De Filippo Profile Picture
    James De Filippo 80 on at
    RE: Web Services to Excel Error: The odata.context URL is invalid

    This is affecting our demo tenant and our live production tenant. Its also affecting all the web services, even the generic ones.

    It doesn't seem to accept our credentials when accessing the URL in the browser.

    Ive tried deleting a web service and re-publishing, however we are getting the same error:

    {"error":{"code":"Authentication_InvalidCredentials","message":"The server has rejected the client credentials.  CorrelationId:  5ce5578d-f29b-43ae-a69e-bae56523d9fc."}}
    [quote user="JAngle"]

    I had a similar issue once with Jet Reports. Try deleting the web service and adding it again and republishing. Try it in the browser before Excel

    [/quote]
  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Web Services to Excel Error: The odata.context URL is invalid

    I had a similar issue once with Jet Reports. Try deleting the web service and adding it again and republishing. Try it in the browser before Excel

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans