Power Platform Dataflows are a solution to import large data into DataVerse. Although they come with a few limitations, in some scenarios they can be a good alternative for recurring imports without the need to go through Azure Data Factory or Azure Logic App expenses. This article assumes that the reader has some background in … Continue reading Power Platform Dataflows – Validating data on import

Working with Dynamics 365 Customer Engagement (D365 CE), at some point or other companies end up needing to connect other system to it. There are different ways to do this connection using OData API calls, using the DataVerse Power Platform Data Flows, and other techniques. Through this article a considerably basic scenario is constructed to … Continue reading Connecting to D365 CE instance using PowerShell module (Microsoft.Xrm.Data.PowerShell)

One of the very reasons to work with JSON files is their ability to represent data as objects and arrays, in simple or complex combinations. When working with JSON files that represent data which was joined from different sources, there is a tendency of ending up with objects containing arrays of other objects. However, the … Continue reading Array concatenation from JSON file using Azure Data Factory