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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Translation of ODATA Endpoint names to Entity or Table names?

(0) ShareShare
ReportReport
Posted on by 436

We are enabling Data Lake and have several Power BI reports that previously used ODATA connections to extract data from our Production D365FO system. Many of these were large tables and hence keen to move them to using Data Lake resident data instead, not least as PowerBI.com is routinely refusing to render any visual that takes more than 225 seconds to load.

As an example, we have one Power BI model accessing ODATA endpoints for:

GeneralLedgerActivities
DimensionCombinations
MainAccounts
FiscalCalendars
DimAttributeProjTables
BudgetActivities

but cannot find any of these in any listing of Entities nor in table names accessible from Data Lake.

Is there a translation table (ODATA End Point to Table or Entity names) available anywhere?

Ian W.

I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    236,320 Most Valuable Professional on at
    RE: Translation of ODATA Endpoint names to Entity or Table names?

    The name is defined in data entity definitions in F&O. In your case, you should look at PublicCollectionName property.

    You can use Metadata search to find entities containing a particular string in PublicCollectionName. For example:

    type:DataEntityView property:"PublicCollectionName=FiscalCalendars"

  • Ian Waring Profile Picture
    436 on at
    RE: Translation of ODATA Endpoint names to Entity or Table names?

    Thank you. I've just got an order in for Visual Studio - awaiting management approval. Then should be able to research the odata endpoint names I need above :-)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,122

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 918 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 646 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans