Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition

CHAPTER 10From Pitfalls to Robust Queries

Data is a precious thing and will last longer than the systems themselves.

—Tim Berners-Lee

IN THIS CHAPTER, YOU WILL

• Learn the main factors in creating weak queries and common pitfalls that lead to refresh failures and incorrect data

• Learn how awareness, best practices, and M modifications can help you prevent the pitfalls

• Learn how to avoid refresh failures due to the automatic detection and change of column types

• Learn how to avoid dangerous filtering that can lead to partial data in your reports

• Learn when reordering the position of columns is effective and how to reorder a subset of columns

• Learn how to remove and select columns and avoid future refresh errors

• Rename columns by their location in ...