PowerQuery hexview

Power Query HexViewer

The Power Query HexViewer displays the raw binary contents of a local text file as a structured hex dump, showing each byte’s address, offset, and hexadecimal value in a table. It reads the file `gitignore_global.txt` using Power Query’s `File.Contents` and `BinaryFormat.List`, then transforms the byte stream with `List.Transform` and `List.Positions` to compute address and offset columns. The final output uses the `#table` constructor to render the parsed data, with `Binary.ToText` formatting each byte as uppercase hex. The visualization relies solely on Power Query’s M language functions, not external JavaScript libraries.

92% match

HEX2DEC one liner implementation in Power Query M

This example demonstrates a compact implementation of hexadecimal-to-decimal conversion in Power Query M, a formula language used in Microsoft Power BI and Excel. It shows how a single-line function can replace a multi-step conversion process. The code defines a custom function named `HEX2DEC` that takes a text string as input and applies the `Expression.Evaluate` API with the literal prefix “0x” to interpret the hexadecimal value. The function then returns the decimal result directly. The visualization highlights the elegance of using M’s expression evaluation for parsing, offering a practical alternative to built-in conversion functions.

64% match

Gist 8abd0d0a72b91b4d72ce79ac9d8ab6c4

This example demonstrates how Power Query’s `BinaryFormat.List` function reads binary data as a sequence of items, returning a list. It shows three distinct modes: reading until the data ends, reading a fixed number of items, and using a condition function to stop based on item values. The code constructs sample binary data with `#binary`, then applies `BinaryFormat.List` with `BinaryFormat.Byte` as the item format. The condition variant passes a lambda `(x) => x < 2` that continues reading while true, including the first failing item. The output lists (e.g., `{1, 2, 3}`) directly display the parsed bytes.

63% match

Power Query navigate the documentation of #shared functions. [M code]

This example visualizes the complete set of functions exposed by Power Query’s `#shared` namespace, organized into a navigable table. It shows each function’s name, module, category, example code, description, and signature. The M code uses `Record.ToTable` and `Table.SelectRow` to filter functions, then leverages `Value.Metadata` to extract documentation fields like `Documentation.Category` and `Documentation.Examples`. It also parses module names via `Text.Split` and builds signatures dynamically. The result is a self-documenting inventory, enabling users to browse and understand the entire Power Query function library directly from the environment.

Dissecting ZIP file structure in Power Query M following explanation from https://users.cs.jmu.edu/buchhofp/forensics/formats/pkzip.html

This example dissects the binary structure of ZIP files using Power Query’s M language, following the PKZIP format specification from James Madison University. It visually parses a ZIP file’s local file headers, central directory entries, and end-of-central-directory records, revealing metadata like compression method, timestamps, and file names. The code leverages `BinaryFormat` combinators—such as `BinaryFormat.Record`, `BinaryFormat.Choice`, and `BinaryFormat.List`—to sequentially read and interpret byte streams, with `Binary.Decompress` handling deflate decompression. The visualization highlights how raw bytes map to structured fields, making the format’s internal layout explicit. Data originates from a sample ZIP file provided as a binary input.

hexbinchart

This example visualizes a label matrix from an orthographic image as a hexbin chart, using color to distinguish between eight different categorical labels. The code loads data from a CSV file, maps each cell’s label to a color using `d3.scaleOrdinal`, and partitions the points with the `d3.hexbin` API. The SVG output renders hexagonal bins clipped to the chart area, with each bin’s fill determined by the dominant label value, producing a gridded heatmap-like representation of the underlying image data.

Sscheenmi@gmail.com

CRC32 implementation in Power Query M mostly inpired by the article about CRC32 computation http://www.sunshine2k.de/articles/coding/crc/understanding_crc.html and Bit Hacks https://graphics.stanford.edu/~seander/bithacks.htm

This example demonstrates a complete CRC32 implementation written in Power Query M, showing how to compute cyclic redundancy checks entirely within a data-transformation language. It displays both the algorithm’s core logic and its practical output as a hexadecimal checksum. The code defines a reverse function for 8-bit and 32-bit values, precomputes a lookup table using a polynomial of 0x4C11DB7, and iterates over input characters with an accumulator function. It relies on Power Query’s `Number.BitwiseAnd`, `Number.BitwiseShiftLeft`, `Number.BitwiseXor`, and `List.Accumulate` APIs. The final result reverses the raw CRC, XORs with 0xFFFFFFFF, and formats it as uppercase hex via `Number.ToText`. The source is a gist by Hugoberry, drawing from external CRC tutorials and bit-hack references.

DEC2BIN or HEX2BIN in Power Query M

This example demonstrates a Power Query M function that converts a decimal number to its binary string representation, implementing the equivalent of Excel’s DEC2BIN and HEX2BIN operations. The function, `Number.DEC2BIN`, takes a numeric input and uses `List.Generate` to iteratively extract bits via `Number.BitwiseAnd` and `Number.BitwiseShiftRight`. Each iteration prepends the least significant bit to an accumulating string, while the loop continues until the remainder becomes zero. The code relies on M’s native `Number.ToText` for bit conversion and explicitly shows the bitwise arithmetic and list-generation logic, with no external libraries or data sources involved.