Abstract
When you build queries using the Power Query designer, the designer creates the query using the M query language. Although you can create robust queries using just the visual interface, there is a lot of useful processing that you can only complete by writing M code. This chapter goes beyond the basics and explores some of the advanced functionality in Power Query, including the M query language, parameters, and functions.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2020 Dan Clark
About this chapter
Cite this chapter
Clark, D. (2020). Advanced Topics in Power Query. In: Beginning Microsoft Power BI. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-5620-6_13
Download citation
DOI: https://doi.org/10.1007/978-1-4842-5620-6_13
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-5619-0
Online ISBN: 978-1-4842-5620-6
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)