Want to level up your #PowerBI game? Here are 8 essential tips for writing better M code in Power Query! 🚀
1️⃣ Use let and in for clean, structured queries.
2️⃣ Keep steps named clearly—avoid Custom1, Custom2!
3️⃣ Buffer data when working with large datasets (Table.Buffer).
4️⃣ Filter early to improve performance.
5️⃣ Use #shared to explore available functions.
6️⃣ Prefer Record.FieldValues over List transformations when possible.
7️⃣ Avoid unnecessary data conversions—minimize Text.From, Number.From, etc.
8️⃣ Comment your code! // Explain transformations
#MQuery#PowerQuery#DataAnalytics#BI
We built Windsurf’s agent to not rely on embedding indexes like other tools out there. One size fits all retrieval simply doesn’t scale for monorepos. Instead, our agent uses tools that a human would to find the context is needs:
- Grep / file find
- File relation traversal (ie. AST parsing)
- Web search online docs
- Parallel LLM-based searches (mquery, see video)
Our agent will converge to human behavior but with infinitely faster speed and capacity to understand.
youtu.be/DuZXbinJ4Uc?si=FVhF…
Finally, @MsmCode has set up a public mquery instance that contains the complete VirusShare collection from @vxunderground (more than 22MM samples). So if you're looking for a quick way to try it out head over to mquery.net/
If you haven't heard about mquery before and you're wondering what it is and what can it be used for, we have a new page on our website dedicated exactly to those questions! cert.pl/en/projects/mquery/
Better documentation, YARA scanning limitation, easier scaling, better user roles. Those are only some of the changes introduced in mquery 1.4!
Full list of changes is available on ⬇️
github.com/CERT-Polska/mquer…
Fell in love with typed-config github.com/bwindsor/typed-co…. It's a tiny Python library for reading config from ini files/environment/anywhere, used by mwdb (and maybe mquery soon). Typed, extensible, dependency free. How does it only have 14 stars on GH?!
Tquery's theory is an adaptation of MQuery, which was introduced by Botoeva, @diegocalvanese, @bcogrel, and Xiao.
If you're interested in theory of semi-structured data, I think that their paper is really worth reading as well:
drops.dagstuhl.de/opus/vollt…
[2/4]
I recommend mquery to test #YARA rules for false positives on a big corpus of indexed goodware
We've even integrated it into our internal VSCode extension via API so that we can trigger a query and get results right into our editors
github.com/CERT-Polska/mquer…