Ultimate access to all questions.
You are managing a Fabric workspace, designated as Workspace1, which hosts a lakehouse identified as Lakehouse1. Within this workspace, you have also set up a data pipeline referred to as Pipeline1. Stored in an Azure Storage account, you possess a collection of CSV files that you need to transfer into Lakehouse1. To accomplish this, you need to include an activity in Pipeline1 capable of copying the data from these CSV files into Lakehouse1. Additionally, this activity must have support for Power Query M formula language expressions. What type of activity should you incorporate into Pipeline1 to fulfill these requirements?