In the previous six chapters, you saw some of the ways in which you can find and load (or connect to) data for the Power BI Desktop data model to use. Inevitably, this is the first part of any process that you follow to extract, transform, and load data. Yet it is quite definitely only a first step. Once the data is in Power BI Desktop, you need to know how to adapt it to suit your requirements in a multitude of ways. This is because not all data is ready to be used immediately. Quite often, you have to do some initial work on the data ...
7. Power Query
Get Pro Data Mashup for Power BI: Powering Up with Power Query and the M Language to Find, Load, and Transform Data now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.