Stop Azure Data Factory Data Flows outputting to multiple files

I came across a recent issue where I was trying to overwrite a single in my Data Flow. However, Data Factory started to output several intermediary files instead.

Filtering in Azure Data Factory

Microsoft have now made it easier to filter records from a delimited source. We all know it's possible to filter SQL data sources, but now filtering in Azure Data Factory…

SQL – Inner Join on Contacts and OptionSetMetadata tables

Using the Data Export Service, you can also query metadata to join customer data into a single flat table. For those trying to get OptionSetMetadata labels instead of code, here…

Create a Dynamics 365 CE Trial Instance with your Azure Student Subscription

I signed-up to an Azure Student Account for an Azure Developers course that I was studying during the evenings. One thing that I noticed immediately was that I could not…

Custom Business Process Flow is not visible in Dynamics 365 CE Unified Interface

If you've created a new Business Process Flow, and you've found that it's not visible in the Unified Interface, you need to add it to the PowerApp Model-Driven App.

Dynamics 365 CE – Set State using a plugin

Below is a code sample that demonstrates how to set the state of a record in Dynamics 365. The plugin Step must be registered on both the SetState & SetStateDynamicEntity…

Get started with Azure Analysis Services

I was looking for some documentation online that would help me run Azure Analysis Services on an Azure SQL DB using Visual Studio 2019. Documentation is sparse so I thought…

Table is required for Copy Activity

I've seen a lot of people manually create tables in Azure SQL when doing a data migration from a source system to SQL DB as the Sink. For those that…

Data import/export framework parameters – Directory c:\temp\dixf\ does not exist

I was working with the on-premise Dynamics 365 Finance & Operations instance, specifically the Virtual Machine when I came across an error setting up a BYOD.

Integration testing with Data Factory, Data Lake, Dynamics 365 Finance & Operation

Just for fun, I decided to play around with Azure Data Factory (ADF), Azure Data Lake Storage (ADLS) and Microsoft Dynamics 365 Finance & Operation VM. I wanted to see…