Automating your Pipelines: A How-To Guide

It’s Friday evening and the inevitable happens; someone says your report is broken. So you slog through six layers of your data pipeline to figure out what went wrong. It is the report refresh? The dataflow? The source tables? The stored procedure? There has to be a better way, right? In this demo, we will create data pipeline automation with Power Automate. We’ll also learn how to automate data integrity checks, looking at both process success/failure and the quantity/quality of the data moved down the pipe. Finally, we will automate some communication with end-users to proactively call out issues before the make their way into production.