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
Connecting to D365 CE instance using PowerShell module (Microsoft.Xrm.Data.PowerShell)
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)
Array concatenation from JSON file using Azure Data Factory
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
Conditional highlighting of a column in Excel
Some years ago, we saw how one can highlight a row in an Excel table based on a cell value. Today, we are going to look into how to highlight a column instead of a row. It is quite similar, so I will only focus on the change required and explain the functions used. To … Continue reading Conditional highlighting of a column in Excel
Simple Aquarium Temperature Sensor
It has been a while that I wanted to leverage the power of ESP-8266 NodeMCU to monitor my aquarium. My first experiment is to read the water temperature every x interval and upload it to ThingSpeak. For this experiment, I need: ESP-8266 NodeMCU; DS18B20 waterproof sensors, which I bought from Amazon; 4.7kΩ resistor. The setup … Continue reading Simple Aquarium Temperature Sensor