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

Business central data sync to dataverse issue

(1) Share

Report

Posted on by Justin Wilkinson

1,338

I am using Data sync and I have created a custom table in dataverse that I want to Map with an OOB business central table however it does not appear within the integration Mappings;

Any suggestions?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at

Like (0)

Report

Hello,

After you click on the Integration Table field you will see all available tables that you can use for mapping.

Ctrl + Alt + F1 and you will see system filters for that view and that the Table Metadata is table linked to this page.

Check your filters, open entire Table Metadata table and check if your custom table is listed in this table.

Was this reply helpful? Yes No
Justin Wilkinson 1,338 on at

Like (0)

Report

thank you for the reply I can't see my table in this list is there a step I have missed?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Please check if you have all the entity permissions assigned to that user which is login in CE side..

Was this reply helpful? Yes No
Justin Wilkinson 1,338 on at

Like (0)

Report

Yes the user is a global admin so that should be fine.

Was this reply helpful? Yes No
Mustafa Omerbegović 1,473 Super User 2025 Season 2 on at

Like (0)

Report

Did you check your Dataverse Connection Setup page in the BC.

There you can see which Dataverse environments is linked to BC, and also you can test your connection.

Do you have other standard tables listed after clicking on the Integration table field on the Integration Mapping?

Was this reply helpful? Yes No
CU09100938-0 10 on at

Like (0)

Report

Thank you.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (0)

Report

Hi, The following step is necessary, otherwise it will not appear here.

Business Central 2024 wave 1 (BC24): Changes to AL Table Proxy Generator tool (altpgen) – Two additional arguments: ClientId and RedirectUri

https://yzhums.com/49871/

More details:

Dynamics 365 Business Central: Customizing an Integration with Microsoft Dataverse (Integrate custom tables)

https://yzhums.com/17065/

Thanks.

ZHU

Was this reply helpful? Yes No