144
An Entity-Relationship diagram (ER-diagram) about all tables, per functional area, for the Base Application and System Application would be extremely helpful.

Anyone that wants to create reports (RDLC, WORD, PowerBI, other) at a certain moment needs to know where to find what information and how the different tables are linked.

Anyone who wants to create an app and add fields to certain tables also needs to clearly understand the database schema of Business Central.

Imho this is essential documentation that is currently very difficult to find. There are bits and pieces available on docs, yammer and github, but it's very difficult to see the trees in the forest ;)

Some advantages on having an ERD:
- Provide a preview of how all your tables should connect, what fields are going to be on each table
- Helps to describe entities, attributes, relationships
- ER diagrams can be used by database designers as a blueprint for implementing data in extensions
- ERD allows you to communicate with the logical structure of the database
Category: Development
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we might consider it in the future.

Best regards,
Business Central Team

Comments

S

Yes - this is long overdue. Customers complain about the marketed ease of use pf Power BI and then the reality in using it with products like Business Central. Suggestion is to transfer marketing budget to product development with the goal of allowing them some semblance of the marketing presentation. Good place to start is ER-diagrams.

Category: Development

S

Regarding this remark:

Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we might consider it in the future.
Best regards,
Business Central Team

How many votes are required for this idea to be added to the roadmap?

Category: Development

S

Very difficult to use POWER BI without a MAP! Any help here is much appreciated. I am trying to produce Financial Report Suite.

Category: Development

S

Really good idea! Would help a lot for getting new developers on track :-)

Category: Development

S

Yes - Advanced customers are also asking for this.

Category: Development