Clounce.com
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
An easy way to create new Policies in Azure is to use the Portal and duplicate an existing policy. However, when working with Infrastructure as Code, using the manual process is not ideal as the new policy won’t be part of the code. An option would be to export the existing policy and update the … Continue reading Creating a Policy with PowerShell
Working with Azure SQL Server, is very similar to working with the traditional on-premise SQL Server. However when it comes to managing users some differences start to become apparent. The first noticeable difference is when trying to create a new login or user. The traditional and user friendly dialog will not appear but instead a … Continue reading 4 Steps to add an SQL managed user to Azure SQL Server