© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
A. BoxA Power BI Compendiumhttps://doi.org/10.1007/978-1-4842-9765-0_9

9. Power Query

Alison Box1  
Billingshurst, West Sussex, UK

People new to Power BI often approach Power Query in the same way they approach data modeling, that is, by ignoring it. This is probably because unless you specifically ask to transform your data, it will be imported into Power BI Desktop relatively unchanged. People often don’t realize that whenever they load or refresh their data, it will pass through the Power Query funnel.

However, just like understanding the importance of a robust data model, Power Query is instrumental in shaping the data to achieve this goal. It would ...

Get A Power BI Compendium: Answers to 65 Commonly Asked Questions on Power BI 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.