Automating a Data Factory pipeline using a runbook seemed like an easy last step in a Azure DWH setup I developed lately. The part in my script responsible to start and stop the DWH ran without problems, but then ...
Automating a Data Factory pipeline using a runbook seemed like an easy last step in a Azure DWH setup I developed lately. The part in my script responsible to start and stop the DWH ran without problems, but then ...
Recently I had a customer providing data for a Power BI report in a format that wasn't ideal for reporting purposes. We solved it by using a combination of pivoting and unpivoting columns. This blog post will show you how to do this.