Presentation Type: Presentation
The Query Editor is possibly the most underutilised tool in Power BI Desktop. People are often more fascinated in the pretty visuals and dashboard reporting, rather than the data transformations that take place before any of this is even possible. The Query Editor enables us to carry out a vast array of data manipulations, but often at a cost. If the transformations are not structured and ordered properly, we can find ourselves watching them complete in what feels like an eternity. So, how can we speed up data transformations in Power BI and in turn, enhance the capabilities of the Query Editor? The answer is query folding. This technique takes the processing strain away from Power BI and the machine you are developing on, instead using the greater capabilities from where the data is sourced. The session will explain query folding in more detail, give examples of where/when it can be used and tips of how to get transformations to perform at their best.