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
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
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.
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.
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,
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.
Share
Report
All responses (
Answers (
238
