Power BI: data transformation — expert reference · Introduction

Introduction

What this guide covers

Comprehensive technical reference on Power Query, the M language and structural, numerical and temporal transformations in the Power BI ecosystem. Expert level.

Overview

Topics covered

Introduction
Data Transformation in Power BI
Introduction and ETL Architecture
Power Query Architecture
Connector Layer
Evaluation Engine M

Related concepts

Main connections

Compatible notation

Mathematical sample in LaTeX

The expression is rendered accessibly, with its LaTeX source preserved below.

\text{Rendimiento}(\mathcal{T}) = \begin{cases} \text{optimum} & \text{if } \mathcal{T} \subseteq \mathcal{F}_{\text{fuente}} \text{ (folding total)} \\ \text{Parcial} & \text{if } \exists\, \mathcal{T}' \subsetneq \mathcal{T}: \mathcal{T}' \subseteq \mathcal{F}_{\text{fuente}} \\ \text{Sub-optimal} & \text{if } \mathcal{T} \cap \mathcal{F}_{\text{fuente}} = \emptyset \text{ (without folding)} \end{cases}

View LaTeX source

\text{Rendimiento}(\mathcal{T}) = \begin{cases} \text{optimum} & \text{if } \mathcal{T} \subseteq \mathcal{F}_{\text{fuente}} \text{ (folding total)} \\ \text{Parcial} & \text{if } \exists\, \mathcal{T}' \subsetneq \mathcal{T}: \mathcal{T}' \subseteq \mathcal{F}_{\text{fuente}} \\ \text{Sub-optimal} & \text{if } \mathcal{T} \cap \mathcal{F}_{\text{fuente}} = \emptyset \text{ (without folding)} \end{cases}