What's New: Dataverse & Dynamics 365 App Integration (2023 release wave 2) Part 2

Overview

The session covers the mission for Dataverse and Dynamics 365 app integration and the four interaction types: data sync, virtual tables, data change events and business events. It then covers improvements to virtual tables, data change events and business events.

A long demo shows Power Pages using virtual tables for anonymous external access, authenticated external access with sales order creation, and internal licensed users. It covers the Microsoft Entra app users, permission sets, Power Pages table permissions, synthetic relations and a Power Automate flow that creates BC customers. The session ends with business events versioning, system tables for troubleshooting and Application Insights telemetry.

Key points

• Virtual tables reach general availability in November. They let Dataverse reach Business Central through the native API without replicating data.
• Power Pages support for virtual tables is in preview. It has three scenarios: anonymous external, authenticated external, and authenticated internal users. Internal users still need BC licensing.
• Data change events capacity rises from 100 to 1000 events per 30 seconds delay. It is controlled by the server settings API subscription max number of notification and API subscription delay time.
• Entra app users have no permission sets by default. An admin must assign them. The demo used wide scopes, but production should use narrow read and write access.
• Synthetic relations link native contacts to virtual tables such as sales orders and invoices. They need a BC customer column on contact, a separate relation per virtual table, and a Power Automate flow that fills the data.
• Business events now support versioning (1.0 adds a web client URL over 0.0) and filtering. Business events are still in preview, with GA targeted for the release after this one.
• The system tables external event subscription and external event activity log help troubleshoot business events. UI pages are due in November 2023. Telemetry goes to Application Insights.

Features

AL objects mentioned

As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.

• table “account table” at 4:34
• table 23 “Vendor” at 4:34
• table 18 “Customer” at 4:34
• table “items table” at 12:32
• table “contact table” at 13:35
• table “sales order table” at 14:16
• table “external event subscription” at 8:49
• table “external event activity loog” at 8:49
• table 5050 “Contact” at 13:35
• table “sales order” at 14:16
• table “sales invoice” at 17:19
• table 27 “Item” at 21:11
• table “D 365 BC item” at 21:11
• table “BC customer” at 23:32
• table “activity lock” at 29:49
• table “posted sales invoice” at 29:07

Not found in BC28-30: table “account table”, table “items table”, table “contact table”, table “sales order table”, table “external event subscription”, table “external event activity loog”, table “sales order”, table “sales invoice”, table “D 365 BC item”, table “BC customer”, table “activity lock”, table “posted sales invoice”.

Quotes

• 1:19 “the mission for data verse integration is to offer extensive Fabric or tools to integrate Dynamics 3 city5 business Central online with other first”
• 2:00 “extensive means we want to cover all type of app or system instructions such as replication or synchronization or what we used to call”
• 6:48 “I’d like to announce the first uh time General availability or GA that’s coming this November for our virtual tables and a big feature”
• 7:08 “we increase the amount of uh event can be processed within 30 seconds delay time it used to be 100 data change event now”
• 8:09 “business event is still in preview and we are targeting a g a in the um in the release after this one”
• 9:29 “power pag support of V fre tables is actually enable access to BC data in three main scenarios the first scenario is anonymous access”
• 11:10 “external user are those user that not in an employee like relationship with your company with your um with the company within business Central”
• 13:35 “when I’m registering I essentially uh creating a new entry in the native contact table inside data verse so this is the registration page”
• 18:12 “there are three Microsoft entra app user created for this scenario the first one is uh already exist before to support uh uh Business”
• 19:13 “admin BC admin actually have to assign permission set for this Microsoft enter app user to make sure that only only relevant uh BC”
• 19:33 “anonymous uh user to read all tables in bc but in practicality when you actually use this uh feature you probably want”
• 22:32 “this is actually um um the concept that we introduced with virtual table where you can actually relate native table with a virtual table”
• 24:18 “the trigger is essentially a data cut event it will listen to the contact table being modified remember when I register as an anonymous”
• 26:19 “there’s a three Improvement in business events right there is a versioning support uh there is uh terrible shooting using system table and UI”
• 26:19 “there is a versioning support uh there is uh terrible shooting using system table and UI page and then uh partner Telemetry”
• 28:06 “the difference between version 1.0 and version 0.0 is uh the payot has uh this new web client URL where you can actually uh”
• 29:30 “the system tables that support troubleshooting for business event the first um uh table is the external event subscription you can see there’s a”
• 30:30 “this is currently still only a system table but uh in pretty soon we’ll provide a UI page that you can actually correlate this”

Disclaimers in the video

• 6:48 preview: the preview of Po Pages support that allow access to busy data from unlicensed user
• 8:09 preview: business event is still in preview and we are targeting a g a in the um in the release after this one
• 19:33 subject-to-change: this is just for a demo purposes in the real practicality you probably should provide a very very narrow uh written and right access
• 20:34 other: by default none of this uh app user has any permission set so by default it’s not enable
• 30:30 coming-later: UI page that you can actually correlate this um uh external subscription with the activity lock in one U nice UI page uh that’s coming in this November

Presenters (as heard): Sandy vinaro, Ivan kage.