You have a Fabric tenant that contains a lakehouse named Lakehouse1. You plan to use Dataflow Gen2 to ingest and transform data from an Azure SQL Database into Lakehouse1. Which language should you us

DAX (Data Analysis Expressions) is used for data modeling and calculations within Power BI semantic models, not for data transformation in Dataflow Gen2.

Dataflow Gen2 in Microsoft Fabric utilizes Power Query for data transformation capabilities. The underlying language for Power Query is the M language, which is specifically designed for querying and transforming data from various sources.

SQL (Structured Query Language) is used for querying and manipulating relational databases like Azure SQL Database, but Dataflow Gen2's transformation engine uses M language, although it can execute SQL for source queries.

XML (Extensible Markup Language) is a markup language for encoding documents and data, and it is not used for data transformation in Dataflow Gen2.