Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Business central data ...
Small and medium business | Business Central, N...
Suggested answer

Business central data sync to dataverse issue

(1) ShareShare
ReportReport
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;


Previewing Image attachment

Any suggestions?
Categories:
Dynamics 365 Business Central
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 75,848 Super User 2024 Season 2 on at
    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
    More details:
    Dynamics 365 Business Central: Customizing an Integration with Microsoft Dataverse (Integrate custom tables)
     
    Thanks.
    ZHU
  • CU09100938-0 Profile Picture
    CU09100938-0 10 on at
    Business central data sync to dataverse issue
    Thank you.
  • Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,090 on at
    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 Profile Picture
    Justin Wilkinson 1,336 on at
    Business central data sync to dataverse issue
    Yes the user is a global admin so that should be fine. 
  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,081 Super User 2024 Season 1 on at
    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 Profile Picture
    Justin Wilkinson 1,336 on at
    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ć Profile Picture
    Mustafa Omerbegović 1,090 on at
    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.
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans