Power Query - Sorting is Sometimes Pointless (VertiPaq Insights)

Understand why sometimes your Power Query sorts are not retained in Excel or Power BI. Learn why this is a non-issue and how to "override" it when dealing with Excel tables as the output. Also, we get an overview of the compression and optimization strategies of the VertiPaq engine when working with data models.

File Download Link:
https://www.bcti.com//wp-content/YT_D...

00:27 Demonstrating the Issue
02:53 VertiPaq Engine (Overview)
04:17 Value Encoding (Example)
05:35 Dictionary Encoding (Example)
06:46 Run Length Encoding (REL) (Example)
07:56 Dual Encoding (Example)
08:54 Moral of the Story
09:25 Sorting does have a purpose in Power Query
09:47 When you SHOULD sort for output
12:03 Fixing "Broken" Sorts
12:25 Refreshing Sorted Data in Excel
13:04 Microsoft's Proprietary Logic