Small and medium business | Business Central, N...

What means each single table in Business Central?

(0) Share

Report

Posted on by KC-25070654-0

Hi everyone,

I would like to create Power BI reports using data from Business Central. When I connect to Business Central using the connector I see many tables. However I do not know what are they used for.

Is there a documentation describing each Business Central tables?

Best,

Kevin

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Teddy Herryanto (Th... 14,306 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Sadly not. There are heaps of tables there. Just play around with it and ask question to your partner or ask here on what you are trying to accomplish.

Was this reply helpful? Yes No
Suggested answer

Olister Rumao 4,009 on at

Like (0)

Report
Copy link

Link copied!

Hi Kevin,

As far as understanding tables goes, you can go through the functionality in Business Central.
At any point, you want to know the pages, tables you can use Page Inspect.
https://docs.microsoft.com/en-us/dynamics365/business-central/across-inspect-page

Then you can use webservices to make those pages accessible to you.
https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/webservices/web-services

Let us know if you need more help,

Was this reply helpful? Yes No
KC-25070654-0 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the documentation however it seems that the name of the of the table in "inspect page" does not fit what is display in "web services". Same for the object id.

Was this reply helpful? Yes No
tanveerk 70 on at

Like (0)

Report
Copy link

Link copied!

Those are datasets, not the actual tables (like a view in SQL server if you are familiar) created by querying the underlying tables.

Was this reply helpful? Yes No
Suggested answer

Olister Rumao 4,009 on at

Like (0)

Report
Copy link

Link copied!

Hi Kevin,

The names of the Table and Pages do not match.

and Webservices use Page and not the table.

So through Inspect you will get the name and the Id of the page you can put this into Webservices you data should match.

Was this reply helpful? Yes No
Suggested answer

JUBEL THOMAS JOY 279 on at

Like (1)

Report
Copy link

Link copied!

Hi Kevin,

As all the community people says there is no direct resource available.

However you trace the same by the help of NAV table relation details available on following link Navision Table relations

Which will help you to find the relation between multiple tables and this is architecture mainly used in Business Central as well. It will match almost 90% of the tables relationships. So have a look on the same.

Thanks and Regards,

Jubel Thomas Joy

Navision Planet

Was this reply helpful? Yes No