Finance | Project Operations, Human Resources, ...

There are lots of new BI-entities - any documentation or other information?

(1) Share

Report

Posted on by Migi

333

MS has recently released much more BI-entities like GeneralJournalAccountEntryBIEntity and CustInvoiceTransBIEntity which can be used for different exporting purposes - but they are not visible in DMF.

My question is mostly, does MS have any documentation or website or sth else where we'd know the list of new entities they release and some additional information like all the fields and type/length?

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Magno Pereira 2,437 Moderator on at

Like (0)

Report
Copy link

Link copied!

There is no official documentation, but all data entities and fields can be queried in the application and development environment.

Configuration keys and data entities - Finance & Operations | Dynamics 365 | Microsoft Learn

You can also use the root service endpoint to list all OData entities available: [Your organization's root URL]/data/

Was this reply helpful? Yes No
Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

After my search, there is no such official document, you can go to the FO app to check the corresponding updates or information.

Best regards,

Kevin

Was this reply helpful? Yes No
Suggested answer

AR-01121610-0 4,969 Moderator on at

Like (3)

Report
Copy link

Link copied!

Hy,

there is a tool to extract all the meta data using a powersehll script. It is located on the Github https://github.com/microsoft/fin-ops-doc-scripts/tree/master

Using this tool I've summarized that data in an shared PowerBI report based on meta data from V.10.038. In this public report you can search and find entities, fields as well as the dependencies to the specific tables and fields.

I also saw all the *BI-entity entities, but these are currently all marked obsolete, not knowing whether these are new or old ones.

Herzliche Grüße / kind regards,

Andreas Raithel

D365FO Solution Architect

Was this reply helpful? Yes No
Suggested answer

Jakob Trasbo 18 on at

Like (0)

Report
Copy link

Link copied!

The BI-entities all pass the validation for Row version change tracking, which is a prerequisite for features like Data archival and Synapse integration.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/rowversion-change-track

Synapse Link for dataverse is the successor to the export to Lata Lake, and all these BI-entities are supported.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/azure-synapse-link-select-fno-data

Was this reply helpful? Yes No