© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2022
A. AspinPro Data Mashup for Power BIhttps://doi.org/10.1007/978-1-4842-8578-7_9

9. Shaping Data

Adam Aspin1  
(1)
STAFFORD, UK
 

In the previous chapter, you saw how to hone your dataset so that you defined only the rows and columns of data that you really need. Then you learned how to carry out basic transformations on the data that they contain. In this chapter, you will learn how to build on these foundations to deliver data that is ready to be molded into a structured and usable data model.

The generic term for this kind of data preparation in Power BI Desktop is shaping data. It covers the following:
  • Joining queries: This involves taking two queries and linking ...

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.