December 2020 – Data Engineering with Salim Saeedi

Using MERGE for SCD Type 2 with multiple updates

December 24, 2020 by admin

Below is the typical MERGE statement for SCD Type 2: Since a MERGE statement cannot update more than one match at a time, in scenarios which the source contains historical data that for each matching key (per ON statament) may need more than 1 action in a single merge statement run (e.g. one INSERT and … Read more

Dynamic 365 Audit History Export through Power BI

December 18, 2020 by admin

Dynamic 365 provides an Audit History in all pages. In case you need to export these data or have a query to the data, Dynamics API provides this access. In Power BI, OData Feed enables this access. In order to achieve this: Use OData source and point it to “audits” entity. Refer to Microsoft’s Web … Read more