Azure Data Factory with Dataverse Lookups - 3 ways to populate
Populating Dataverse lookups with Azure Data Factory is harder than it should be. We broke down how to do it.
Free Solutions Architecture Training:
https://www.untethered365.com/freetra...
0:00 Intro
0:16 Using GUIDs
3:40 3 Requests
7:30 Dataflows
Andrea's tutorial (FetchXML)
• SQL to Dataverse Data Migration using Azur...
Denis' Tutoiral (Dataflow)
• Updating and Inserting Lookup fields in Da...
Other concept to look into:
https://learn.microsoft.com/en-us/azu...
If you use an “inline” sink instead of a dataset within the dataflow, you can actually select the alternative key on the lookup instead of having to construct additional columns. Also means you dont need to configure a dataset. It’s quite nifty :)
#dataverse #azuredatafactory