Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
This article explains how to enable dual-write from Microsoft Dynamics 365 Lifecycle Services.
Customers must complete the Power Platform integration as described in the following topics:
Follow these steps to set up dual-write from Lifecycle Services Environment Details page:
On the Environment Details page, expand the Power Platform Integration section.
Select the Dual-write application button.
Review the terms and conditions, and then select Configure.
Select OK to continue.
You can monitor the progress by periodically refreshing the environment details page. Setup typically takes 30 minutes or less.
When the setup is complete, a message informs you if the process was successful or if there was a failure. If the setup failed, then a related error message is displayed. You must fix any errors before moving to the next step.
Select Link to Power Platform environment to create a link between Dataverse and the current environment's databases. It typically takes less than 5 minutes to create the link.
When the linking is complete, a hyperlink is displayed. Use the link to sign in to the dual-write administration area in the finance and operations environment. From there, you can set up entity mappings.
Certificates in your Microsoft Entra tenant are no longer installed in new one-box development environments by default. To enable dual-write on a one-box environment, you must grant the application user configured for the environment with a role and permissions for dual-write. To configure these permissions:
Open the Power Platform admin center.
Select your environment where you're configuring dual-write, and select Settings on the environment details page.
On the Users + permissions list, select Application users.
Select the New app user action.
On the Create a new app user pane:
Enable the "DualWriteUnoAuthenticationFnoToCds" flight:
DECLARE @flightName NVARCHAR(100) = 'DualWriteUnoAuthenticationFnoToCds';
IF NOT EXISTS (SELECT TOP 1 1 FROM SysFlighting WHERE flightName = @flightName)
INSERT INTO SYSFLIGHTING(FLIGHTNAME, ENABLED, FLIGHTSERVICEID, PARTITION)
SELECT @flightName, 1, 12719367, RECID FROM DBO.[PARTITIONS];
ELSE
UPDATE SysFlighting SET enabled = 1, flightServiceId = 12719367 WHERE flightName = @flightName;
Note
If permissions for the application user are not configured for your one-box environment, you may receive the following error message during dual-write sync operations: "0x80072560 response message: The user is not a member of the organization".
It's possible that your dual-write environment is linked to a Dataverse instance while Lifecycle Services isn't set up for Power Platform integration. This linking mismatch can cause unexpected behavior. It's recommended that Lifecycle Services environment details match what you are connected to in dual-write so the same connection can be used by business events, virtual tables, and add-ins.
If your environment has a linking mismatch, Lifecycle Services shows a warning on your environment details page that resembles the following example: "Microsoft has detected that your environment is linked via Dual-write to a different destination than specified in Power Platform Integration, which isn't recommended."
If you receive this warning, try one of the following solutions:
In the past a manual support ticket option was available, but that was before option 1 above existed. Microsoft no longer supports manual relinking requests via Support tickets.
It's possible to receive the following error while linking the finance and operations environment to the Dataverse environment in Lifecycle Services:
Error code | Error message |
---|---|
DW9003 | Failed to connect to CRM. Ensure that the service principal has the correct permissions to access CRM. |
DW9003 | Failed to connect to AX. Ensure that the service principal has the correct permissions to access AX. |
This error indicates that the application users created for dual-write to access data on the target platforms haven't been configured with the appropriate permissions. To resolve this error, ensure the application users are configured correctly following the guidance in System requirements and prerequisites.
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn more