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

Business central data sync to dataverse issue

(1) Share

Report

Posted on by Justin Wilkinson

1,336

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

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 74,115 Super User 2024 Season 2 on at

Like (0)

Report

Business central data sync to dataverse issue

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
CU09100938-0 6 on at

Like (0)

Report

Business central data sync to dataverse issue

The issue might be due to the custom table not being exposed properly for integration in Business Central or Dataverse. Ensure that the custom table is marked as "integratable" and check the mapping settings in Data Sync. You may need to refresh or update the metadata in both systems. I recently used oxessays https://oxessays.com/write-my-essay for an essay I was struggling to complete. The result was fantastic! The writer provided a well-structured, high-quality paper that met all my requirements. I was impressed with how quickly they completed the task and how easy it was to communicate with their customer support. If you need help with writing essays, I highly recommend this service. They deliver top-notch work every time!
Mustafa Omerbegović 1,079 on at

Like (0)

Report

Business central data sync to dataverse issue

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?
Justin Wilkinson 1,336 on at

Like (0)

Report

Business central data sync to dataverse issue

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

Nitin Verma 21,091 Super User 2024 Season 1 on at

Like (0)

Report

Business central data sync to dataverse issue

Please check if you have all the entity permissions assigned to that user which is login in CE side..
Justin Wilkinson 1,336 on at

Like (0)

Report

Business central data sync to dataverse issue

thank you for the reply I can't see my table in this list is there a step I have missed?
Mustafa Omerbegović 1,079 on at

Like (0)

Report

Business central data sync to dataverse issue

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.