web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Opening OData in Excel
Finance forum

Opening OData in Excel

(0) ShareShare
ReportReport
Posted on by nspiteri 545

So in D365 for Finance and Operations we have entities exposed as OData.  I would like to be able to open the OData in Excel.  I go to the Data tab on the ribbon, choose OData and give it the path to my OData Service (<axurl>\data\<entity>).

I have 2 options for security - use current or define.  Whichever I choose the result is always a 401 unauthorized (I would have hoped I'd get some way to login at least).  I tried on Excel 2013 and 2016.

Any tips how I can do this?

Thanks

Categories:
Finance and Operations
I have the same question (0)
  • FandaS Profile Picture
    FandaS on at

    Hi Norbert,

    Maybe your question is no longer valid.

    I had the same issue and the functional way is use option:

      - Ribbon Data > Get & Transform> New Query> From Other Sources> From OData Feed

      - Ribbon Data > Get & Transform> New Query> From Other Sources> From Dynamics 365 (online)

    The result is the same - list of entities for use

    FandaS

  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 238,782 Most Valuable Professional on at

    Dynamics 365 (online) isn't Dynamics 365 for Finance and Operations. Are you sure it can be use with D365FO?

    The right approach in D365FO (AFAIK) is using the Excel add-in developed by Microsoft. It handles authentication, among other things.

  • Verified answer
    Mariusz Tracz Profile Picture
    Mariusz Tracz 5 on at

    I have the same issue, and the solution is to use in Excel:

    Data- New query - From other sources - From OData,

    put in url your application link: usnconeboxax1aos.cloud.onebox.dynamics.com/.../

    then use credentials (with Organisation account) from Dynamics 365 F&O,

    Best

    Mariusz

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans