Mark Kromer meets a challenge:
Today, we don’t have an option in data flows in ADF to include headers when your transformations result in zero rows. But you can build the logic to handle this scenario. So, until we add a checkbox feature to include headers, you can use this technique below to achieve this.
Click through for the explanation, as well as a completed version you can take for your own.