Power Automate is not that great at consuming a Word file (in comparison to Excel). This post hopes to try and alleviate some of the pain points you may be suffering.

A simple way to use Power Automate to enable importation of a Summary Excel Workbook into 3rd party reporting tools.

This post outlines how to add a Service Principal connection for Dataverse to a Managed Power Automate Solution.

So a little while ago I showed some examples of using Power Automate and Excel files. One of the major caveats of using the Excel files was that there needed to be a defined data table in the Worksheet of interest. This blog post will show you a way to get around that limitation…

Power Automate is an online tool designed to make your life easier and more productive. This article will show you how to do this with Excel in a way to get rid of the good old manual copy and paste that is a bane of many peoples existence.

So there you are having created a work of beauty in Sparx Enterprise Architect that models all of your databases, and then the fly lands in the ointment.  There's a new version of "stuff" coming down the pipeline and you need to update the model or things are...

Recently down on a client site I had the opportunity to work with Sparx Enterprise Architect on a project.  For those of you not familar with the product the easiest way to describe it would be to imagine a coffee drinker used to simple old joe walking into a...

I think we can all agree that it is nice to get things for free when we can, and so I thought of this post about how to set up your local development machine to run U-SQL jobs for development and ad-hoc purposes rather than submitting them to Azure Data Lake Services...

Never has the phrase "a picture is worth a thousand words" been truer - well, in this case, a thousand words refers to lots of bits of code but you will soon see what I mean.  In a previous post (Two Cans and a piece of string (Azure Data Factory)) I showed how to...

In my previous post about Azure Data Lake Store, I went over how to create one and what it can be used for.  So assuming that you've created one and started to stock it with data and information - just how do we go about fishing out what we want? Let's talk about...

So it got near the end of the month for my "free" Azure trial and I need to change it up to a pay-as-you-go subscription if I want to keep playing with it. Switching to a Pay-as-you-Go subscription Assuming that you want to continue enjoying the azure goodies you will...

In my last post I plunged into the Azure pool and created a SQL Database.  Now lets do what we always do with a database and start to fill it up.  For this post I'm going to concentrate on the Azure Data Factory product and see how it helps us perform ETL (or ELT)...

So in a previous post I outlined a large collection of the free stuff that Microsoft gives you when you sign up to Azure.  So enough talking lets get our feet wet.. The pull tab to get us started is located at https://azure.microsoft.com/en-us/free/ where there's a...

Previously we outlined how to create the SSIS packages for ODE to load data into staging tables as a part of the table load. The steps were defined explicitly for use with BimlStudio which is a paid product from Varigence, but if you planning on doing things in a more...

So after having been down at a client site where they were using Microsoft Azure to host their database servers, I was inspired to learn more about this Azure thingy (ooh shiny).  So I thought lets try and set up a collection of blogs about travels through the Azure...

So there we were, Client site and they wanted a large load of tables brought over from a bunch of different source systems.  They had Microsoft SQL Server (well Azure in the cloud <hand waving>) and so we needed to use Integration Services (SSIS to be precise -...