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

Business central Integration with Dataverse

(2) Share

Report

Posted on by Power Platform

Actually, I'm working on the intégration of Business central and Dataverse and i also get my virtuelles tables in Business central , but i facing come incomprehension about the process .

As you know, in my virtuels tables i need to get all apis pages but I'm not getting the table "Resources" From business central , do you know why ?
I'm not getting all field for each table (ex: in the table costumer in BC, i have so many fields and some are joined with the resource table but in my customer virtuel table i don't all the Field) , do you have any idea ?

Thanks in advance for your answers :)

All responses (2)

Answers (0)

Suggested answer

Greg Enns 1,102 on at

Like (0)

Report

RE: Business central Integration with Dataverse

This should help to explain your options:

www.youtube.com/watch
Suggested answer

YUN ZHU 82,673 Super User 2025 Season 1 on at

Like (0)

Report

RE: Business central Integration with Dataverse

Hi, First of all, this function does not support to all tables in BC.

For example, in 2022 release wave 1 (BC20), Map to Dataverse option sets such as payment terms, freight terms, and shipping agents without code

https://docs.microsoft.com/en-us/dynamics365-release-plan/2022wave1/smb/dynamics365-business-central/map-dataverse-option-sets-such-as-payment-terms-freight-terms-shipping-agents-without-code

As far as I know, this is because when integrating with Dataverse, it is not directly connected to your Customer table, there is an intermediate table. This table is generated by AL Table Proxy Generator, and This table is set to the table type CDS.

I think you can find more info in the following.

https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/administration/administration-custom-cds-integration#extend-the-contact-table-and-page-with-the-industry-field

https://yzhums.com/17065/

Thanks.

ZHU