Although Power Pivot provides many types of connections that you can use to query data, there are times when you need to clean and shape it (commonly called data munging) before loading it into the model. This is where Power Query really shines and is a very useful part of your BI arsenal. Power Query provides an easy-to-use interface for discovering and transforming data. It contains tools to clean and shape data such as removing duplicates, replacing values, and grouping data. In addition, it supports a vast array of data sources, both structured and unstructured, such as relational databases, web ...
© Dan Clark 2017
Dan Clark, Beginning Power BI, 10.1007/978-1-4842-2577-6_3
3. Data Munging with Power Query
Dan Clark1
(1)Camp Hill, Pennsylvania, USA
Get Beginning Power BI: A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop, Second Edition 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.
