This Post Has 13 Comments

1. A great foundational reference for Power Query (M)
   I have been working with Power BI for 8 years and have been about as deeply immersed in Power Query as one can be for most of that time. I’m only 400 pages in but have already learned several techniques and concepts I didn’t know I was missing. This has served to tie together other key concepts and strengthen my skills.While I agree with an earlier reviewer who wrote “This book is geared more for someone familiar with Power Query”, somebody new to Power Query who recognizes the importance of learning to use this powerful data transformation tool will find this to be a vital resource.This book stands out among so many technical books in that it functions equally well as one you can read through from front to back while working through the examples and as one you can go to when researching a solution to a specific challenge.

   Reply

2. Outstanding
   Lot of useful information with examples. Great reference

   Reply

3. Great resource for those who want to focus on M, not Dax
   I have several Power BI books but most focus more on Power Pivot and Dax than Power Query. This book is enormous and it’s all PQ. I’ve got the thing bookmarked from front to back. Great reference for problem-solving and detailed PQ knowledge.

   Reply

4. A Great book for learning Power Query M language
   As a seasoned Power Query user, I recommend this book to the ones who want to learn Power Query M lanhuage.I just finished the chapter 5 of this book, Understanding Data Type, in which I learned that we can ascribe a data type in certain functions without actually processing a type transformation. This idea is new for me, and by using this we can enhance the performance of query. Looking forward to the following chapters.

   Reply

5. A Game-Changing Resource for Power Query Enthusiasts!
   As someone deeply immersed in the world of data analysis and Power BI, I’ve eagerly awaited a comprehensive guide that truly unlocks the potential of Power Query. “The Definitive Guide to Power Query (M)” exceeds all expectations and stands as a monumental achievement in the field.Having had the privilege of interacting with Melissa de Korte, Greg Deckler, and Rick de Groot on several occasions, I can attest to their expertise and dedication to empowering data professionals. Their passion shines through every page of this book, making complex concepts accessible to both novices and seasoned practitioners alike.What truly sets this book apart is its practical approach to mastering complex data transformations. The authors don’t just teach you how to use Power Query; they equip you with the skills to tackle real-world challenges with confidence and efficiency. The depth of coverage is unparalleled, providing insights and techniques that I’ve struggled to find elsewhere.I’d be remiss not to express my heartfelt gratitude to Brian Julius, whose mentorship and guidance played a pivotal role in my journey through the realms of data analysis and Power BI. His expertise and encouragement have been invaluable, and I’m thrilled to see his influence acknowledged in this book.”The Definitive Guide to Power Query (M)” is more than just a reference manual; it’s a roadmap to mastery. Whether you’re a data analyst, business intelligence professional, or enthusiast eager to harness the power of Power Query, this book is an indispensable companion on your quest for excellence.In conclusion, I wholeheartedly recommend this book to anyone seeking to elevate their data analysis skills and unleash the full potential of Power Query. Melissa, Greg, Rick, and Brian have created a masterpiece that will undoubtedly leave a lasting impact on the data community.Bravo!

   Reply

6. Great Resource for M for Power Query Users of All Levels
   The book begins with a brief history on the M Language then moves into the Power Query Editor. It provides you with step-by-step instructions to guide you through examples with practice files. It highlights topics such as Nested Structures, Working with Dates and Times; Splitting, Replacing, and Combing Text, Debugging, Query Optimization, and Extensions to name a few areas. While I’ve used Power Query and M for several years, I recommend this book as there is always more to learn and it can serve as a great reference for both beginners and experienced Power Query users.

   Reply

7. Not for beginners but will help gain more knowledge!
   This book is geared more for someone familiar with Power Query. I have used Power BI for several years and this book is a benefit.I could have used this on a consulting project when I needed knowledge for query folding as discussed in this book.Overall it is an excellent resource for anyone wanting to get the definitive explanation of Power Query/M.Even if you have no prior experience get it. It will be hard at times but the knowledge you gain will be worth it.I would recommend this book to my colleagues and plan on using this as a reference.

   Reply

8. Cracking the code on Power Query
   Was recommended this book since I work in Power BI and Power Query (M) daily and it has been fantastic. I often have used tables such as a calendar table and admittedly had copied and pasted into the advanced editor what others had built. Now this book makes me feel like I’ve cracked the code into understanding exactly what is going on and making custom changes I wouldn’t otherwise be able to do in the UI experience of transforming data. It’s well worth it to take your time with this book and understand the M power query language more in-depth. The authors did a great job of breaking it down.

   Reply

9. This is the missing piece for anyone looking for M information. I have reached the point where the UI and minor tweaks in the advanced editor no longer meet every need. This book is helping me to go to the next level.

   Reply

10. The item is very good and as I expected

    Reply

11. This book contains valuable information about power query.

    Reply

12. As a Data Analyst Tutor, I highly recommend “The Definitive Guide to Power Query (M)” by Greg Deckler, Rick de Groot, and Melissa de Korte.I believe that If you work with data, this book is a game-changer, whether you’re new to Power Query or an experienced user. The authors excel at breaking down even the most complex topics into clear and easy-to-understand explanations. It’s like having your own personal Power Query tutor on hand, ready to answer your questions at any skill level.Forget theory overload! This book focuses directly on what you need: accomplishing tasks with Power Query. It starts with the basics of data wrangling and then takes you up to some seriously impressive M code. The best part? There are tons of real-life examples and tutorials, so you can put your newfound skills to work right away. This really helped me level up my skills in my application for M. Lots of best practices to take away!I’d recommend it to anyone who’s looking to learn more.I think this book is a treasure trove, whether you’re new to data analysis or looking to streamline your prep work. The chapters are awesome – easy to jump into specific topics if you need a refresher, or perfect for a deep dive cover-to-cover. Plus, they wrap up nicely with clear summaries, so you never feel lost. It’s like having a cheat sheet for anything data-related.Moreover, the GitHub code bundles included are extremely useful for hands-on practice with the book’s material. The authors also delve into advanced topics such as custom functions, enabling extensions, and using nested structures, making this resource particularly comprehensive and insightful.This book is a fantastic investment for anyone serious about leveraging the full potential of Power Query in Power BI or Excel. I will be using it regularly to bring back some best practices to my training and share with my apprentices what I have learned from it.To finish this, I would like to thank Brian Julius for all the recent posts related to Power Query lots of them link to this book, and the foreword of this book of course.Thanks to Vignesh Raju 💯🚀🎯📈 Raju for allowing me to read this fantastic masterpiece, next “Extending PowerBI with Python and R”.Wish me luck, these are beasts I always wanted to tame!

    Reply

13. Book is so good, build quality is very goodContents are are so usefull to understand m languageImpressBut after publisers in India is so badWhen you u have to wait when this book will be dispatched, like after order only they are going to print and after print they dispatch the bookEven one time I got wrong book even non topic like medical bookAfter ao many try order and cancelling the order again order I got the bookCost is little high but good as on now approx rs1800

    Reply