Book

Power Query Cookbook

Power Query provides an easy-to-use GUI that allows you to achieve powerful data transformations within the M programming language. This book will show you how easy it is to learn the M language and its many AI-powered functions for auto-generating M code. It will also prepare you to use complex M functions.

Offered byPackt Logo

Difficulty Level

Intermediate

Completion Time

13h44m

Language

English

About Book

Who Is This Book For?

This book is for data analysts, BI developers, data engineers, and anyone looking for a desk reference guide to learn how Power Query can be used with different Microsoft products to handle data of varying complexity. Beginner-level knowledge of Power BI and the M Language will help you to get the best out of this book.

Book content

chapters 13h44m total length

Getting Started with Power Query

Connecting to Fetch Data

Data Exploration in Power Query

Reshaping Your Data

Combining Queries for Efficiency

Optimizing Power Query Performance

Leveraging the M Language

Adding Value to Your Data

Performance Tuning with Power BI Dataflows

Implementing Query Diagnostics

Related Resources

Access Ready-to-Use Books for Free!

Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!

No credit card required