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

Notifications

Announcements

No record found.

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
    237,976 Most Valuable Professional on at

    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

    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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 422 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans