Microsoft provides a good documentation on how to ingest monitoring data over event-hubs and preparing it for Azure Data Explorer, Tutorial: Ingest and query monitoring data in Azure Data Explorer. The solution provided by Microsoft collects all Diagnostic data in a central table, which is counterproductive if alerts or detailed queries are needed. So how … Continue reading Azure monitoring data event-hub integration 

When developing solutions, it is not uncommon to encounter situations where Azure Functions are required to perform some tasks. For example, creating an API interface, or handling some complex execution out for a logic app. A common question that always arises is how to deploy everything together, while allowing software developers to still build and … Continue reading Azure Functions with File Contents using Bicep

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