Translation of ODATA Endpoint names to Entity or Table names?

(0) Share

Report

Posted on by Ian Waring

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.

All responses (2)

Answers (1)

Ian Waring 436 on at

Like (0)

Report

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 :-)
Verified answer

Martin Dráb 233,013 Most Valuable Professional on at

Like (2)

Report
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"