London, England
Joined October 2009
- Tweets3.4K
- Following736
- Followers1.5K
- Likes9.2K
Pinned Tweet
Forget about writing your own DAX parser.
You can pass a valid DAX query to👇
$SYSTEM.DISCOVER_CALC_DEPENDENCY
And get all the underlying dependencies in under 100ms.
Peeps parsing the Log Analytics traces know what I'm talking about😉
ALT PowerBI, Log Analytics trace parse
Igor Cotruta retweeted
I’ve spoken to over 50 people 1:1 over the last several months to better understand how they code with AI.
It’s an absolute mess.
Here are the top 8 mistakes I see.
0:00 - Intro
1:19 - Mistake 1: Talking to 2026 models like they’re 2025 models
2:43 - Mistake 2: Devising funky metaphorical factories to orchestrate your agents
3:59 - Mistake 3: Treating context as sacred
6:02 - Mistake 4: Treating previous conversations as sacred
7:59 - Mistake 5: Having a todo list
10:00 - Mistake 6: Using funky tools
13:47 - Mistake 7: Stressing over code quality
24:27 - Mistake 8: Using branches and worktrees
Hey, Jev promoters, have you ever called the OpenAI API with logit_bias? It's been there from the very start.
You can also count it as free output tokens.
Igor Cotruta retweeted
Change a few DuckLake defaults and you get a 30% speed boost. Partition and cluster well and the gains can be bigger.
Matt Martin and I just finished the performance optimization chapter of the @OReillyMedia Definitive Guide, and we're giving it away!
motherduck.com/lp/ducklake-l…
Igor Cotruta retweeted
Everything runs client-side in the sidebar. No backend.
Maybe the small beginnings of a BI tool, with GSheets as the frontend
Details:
sqlcell.com
Install:
workspace.google.com/marketp…
Igor Cotruta retweeted
I put DuckDB-WASM in a Google Sheets sidebar.
Attach Parquet, Avro, PBIX, SQLite, GeoJSON and a bunch of other formats, query them with DuckDB, then write the result straight into the workbook.
It also works with httpfs/S3, DuckLake and Iceberg.
I put DuckDB-WASM in a Google Sheets sidebar.
Attach Parquet, Avro, PBIX, SQLite, GeoJSON and a bunch of other formats, query them with DuckDB, then write the result straight into the workbook.
It also works with httpfs/S3, DuckLake and Iceberg.
Everything runs client-side in the sidebar. No backend.
Maybe the small beginnings of a BI tool, with GSheets as the frontend
Details:
sqlcell.com
Install:
workspace.google.com/marketp…
Igor Cotruta retweeted
I was talking to a friend about serving customer-facing dashboards with just Cloudflare R2 & Hyparquet for range queries ~ no db required. Turns out it's fast!
first time I haven't reached for DuckDB for this use in while, though naturally I did use it to build the datacube
PowerShell dissecting Power Pivot sounds like Power Awesome.
Power Pivot hides a compressed Analysis Services database inside an .xlsx. The fun part: Windows already knows how to decompress it.
~30 lines of PowerShell. No pip. No Cython. Nothing to install.
Full write-up, with the ABF container walked end to end:
pbixray.com/posts/powerpivot…
Install-Script -Name Show-PowerPivotModel
Power Query's enum promises seven codecs. Binary.Decompress delivers two.
The other five are sitting right there inside Parquet.Document.
So I built them a door. 150 bytes of Parquet scaffolding and Snappy, Brotli, Zstd and LZ4 all work in plain M.
ALT Power Query decompression for Snappy, Brotli, Zstd and LZ4 via a codec oracle Parquet.Document function
One .pq file. Paste into a blank query and you are done.
Same signature as Binary.Decompress, so Codec.Decompress(blob, Compression.Zstandard) just works. It even digs the decompressed size out of the stream so you don't have to know it.
Code, fixtures and a probe query for your own box: github.com/Hugoberry/powerqu…
Igor Cotruta retweeted
Probably my favourite part of PBIXRay: select a PBIX file in Finder, press Space, and get a glimpse of its model and report structure without opening the app.
Probably my favourite part of PBIXRay: select a PBIX file in Finder, press Space, and get a glimpse of its model and report structure without opening the app.
Native macOS. Everything is parsed locally, with no uploads or telemetry.
apps.apple.com/app/id6787160…
Igor Cotruta retweeted
PBIXRay wants your ABF files 🫵
New in pbixray: you can now inspect .abf files directly from Python.
Working with PBIP? Inherited a project? Found yourself staring at a cache.abf wondering what’s inside?
You no longer need to restore it first.
Peek into the model, metadata, partitions, and extract the data you need.
PBIXRay wants your ABF files 🫵
New in pbixray: you can now inspect .abf files directly from Python.
Working with PBIP? Inherited a project? Found yourself staring at a cache.abf wondering what’s inside?
You no longer need to restore it first.
Peek into the model, metadata, partitions, and extract the data you need.
