Fabric Warehouse to CRM

[southgrad10]

We use Microsoft Dynamics 365 Business Central and have the data in warehouse in Fabric.  The Customer ID is a guid and we are attempting to insert the guid into the Customer field of the Sales Invoice form/entity, but the target field in the entity (Sales Invoice Header) in CRM is of lookup type!

Has anyone had this experience?

[v-nikhilan-msft]

Hi @southgrad10 
Thanks for using Fabric Community.
Can you please refer to this thread? This might help you.
Solved: unable to Import data into Dataverse table with a ... - Power Platform Community (microsoft....

If this doesnt help you please let me know. I will provide further help and solve your query.

Thanks.

[southgrad10]

I can't get Eric's link to come up.

[v-nikhilan-msft]

Hi @southgrad10 
Apologies for the inconvenience.

Please reach out to our support team so they can do a more thorough investigation and help you.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

[v-nikhilan-msft]

Hi @southgrad10 
We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket. If yes please share the details here. Otherwise, will respond back with the more details and we will try to help.
Thanks