Tag: Synapse Link for Dataverse

Fetching App

Today I set up Synapse Link to a “Bring Your Own DataLake” for a customer. When I went through the configuration in SynapseLink and I had configured my D365FO Entities the process hung at the status Message “Fetching App”

After I looked around a bit I found the solution on Yammer… The issue was that the Service Principal for Common Data Service – Azure Data Lake Storage was missing from Microsoft Entra ID.

The solution:

New-AzADServicePrincipal -ApplicationId 546068c3-99b1-4890-8e93-c8aeadcfe56a

This command needs to be run by someone who is an Azure Admin on the tenant level

Note: While researching this, I also saw that the Service Principal for Power Query Online (AppId: f3b07414-6bf4-46e6-b63f-56941f3f4128) also might be missing. In that case… Run this: New-AzADServicePrincipal -ApplicationId f3b07414-6bf4-46e6-b63f-56941f3f4128

Good Luck

Issues syncing Sales Order Lines with Dual Write

I am doing some experimenting with Synapse Links for Dataverse and to do that I need my FnO data in Dataverse. The way I do it, is using Dualwrite. When I try to sync Sales Order Lines V2 to salesorderdetails I get the following error:

Reason: Bad Request, Header x-ms-client-request-id f1004256-8a98-42fe-86a9-02b8e64a81a9, Produkten kan inte läggas till eftersom den inte är aktiv

(for those of you, not fluent in Swedish it says “The product cannot be added because it is not active)

This means that the product is synced but it is not active. To activate the product it needs to be published. To do this go through the following steps:

  1. In Sales open products
  2. Select a product and click Publish

The problem was I had a couple of thousand products. So I googled and found this forum thread helping me to write a workflow to automate it (this is way beyond my knowledge in CRM).

Links:
https://learn.microsoft.com/en-us/dynamics365/sales/publish-product-bundle-make-available-selling
Bulk publishing products – Dynamics 365 Sales Forum Community Forum