Updating and Inserting Lookup fields in Dataverse with Azure Data Factory (ADF) inside Data Flows скачать в хорошем качестве

Updating and Inserting Lookup fields in Dataverse with Azure Data Factory (ADF) inside Data Flows

I found an interesting behaviour when inserting/updating Dataverse's lookup fields in DataFlows with ADF. The only instruction for the lookup fields you can find on the internet is about the "Copy" activity in the "Pipelines", which doesn't work for DataFlows. Exceptions you receive don't show any meaningful info, just generic errors. There is no simple solution on the internet. The only one I found was to use DataFlow to prepare and transfer the data to a blob file and then copy this data to Dataverse (by using the "Copy" activity in a Pipeline). But this is overcomplicated and costs extra $. In this video, I share the easiest way to do this. Also, here's the text version of the same talk:   / updating-inserting-lookup-fields-dataverse...   #dataaalysiz #dataanalytics #financialdata #accountingdata #powerbi #bi #datavizualisation #datavizualizatio #dataanalysis #sdcentrum #dataintegration #dataquality #datastrategy #datamapping #dataframework #datagovernance #azuredatafactory #dataverse #lookupfields