O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required