Štěpán Rešl

@chandeep2786 Suppose you add a type definition to the table.AddColumn like “, type [A=number, B=text]” after expanding columns; this will persist the data type.

Most people create columns one by one in Power Query. But you don’t have to. You can write all the logic inside a single record, expand it once, and get multiple columns in one go. Cleaner, faster, and much easier to manage. P.S. - Hyderabad folks, I’m in town and doing an in-person meetup tomorrow, 21st Mar 11 AM at Café Coffee Day, Sarath City Capital Mall. If you’re around, come say hi. I always enjoy these meetups because everyone brings different experiences and perspectives, and the conversations are always worth it 😀 See you there!

You can now schedule recurring cloud-based tasks on Claude Code. Set a repo (or repos), a schedule, and a prompt. Claude runs it via cloud infra on your schedule, so you don’t need to keep Claude Code running on your local machine.

I might have gotten a little crazy...

Projects are now available in Cowork. Keep your tasks and context in one place, focused on one area of work. Files and instructions stay on your computer. Import existing projects in one click, or start fresh.

Claude Code 2.1.80 has been released. 1 flag change, 17 CLI changes, 1 system prompt change Highlights: • Memories are checked against current files before use to avoid relying on stale data • Sessions restored with --resume include all parallel tool results, replacing '[Tool result missing]' errors • Many previously blocked SQL analysis functions reinstated, restoring prior SQL workflows and outputs Complete details in thread ↓

What SHOULD happen? A brand new workload, Fabric Planning, may help you look into the future. Just announced at #FabCon Atlanta

Do you know that we have already opened the Call for Speakers for the Prague Power Conference? Link: sessionize.com/power-conferen…

@kurtbuhler Yep, that might be that bell

@tpnRel1 You might be referring to my custom markdown editor.

Data analysts, BI professionals... people who create dashboards and data models in SSBI tools... I think these roles have a big advantage for effectively using AI and coding agents. In this video, I explain why, and show examples of things I've made in the last 1-2 months.

@kurtbuhler Kurt, I have one question, and I am honest, that I haven't been able to watch your video yet.But I havee seen that you were usingan interesting UI for Claude.

Link (YouTube): youtu.be/hr_olwi7m4M Note: I'm not trying to sell you anything, I have no affiliation with Anthropic. I've had a lot of fun, enablement, and self-satisfaction using coding agents in the last year, and I hope others can experience that, too.

Sometimes you just need to see what your M (Power Query) code is actually doing — and that’s not always obvious. I added an Execution Plan to M-Game: run your code, open the plan, inspect the flow + intermediate results ✅ mgame.datameerkat.com #PowerQuery #MLanguage #PowerBI

@KratosBi Also, I will be unlocking challenge topics, so anyone will be able to try them, without previously completing the rest

@KratosBi Initially, I was using stars to measure users' success based on whether they used hints. I have removed the star system, but I have left achievements as a small remember

Fabric Fridays #111 - Power Query Training - Štěpán Rešl x.com/i/broadcasts/1…

This might be interesting for you guys: ( @PowerBITips , @PowerBIWeekly )

I have implemented a few updates: > New topic: Data Formats > +25 new levels > Playground page > 404 Page > over 599 supported functions/enumerators > Improved M logic (better error support) Link: mgame.datameerkat.com #M #PowerQuery

I built an online practice app for M (Power Query) 🚀 ✅ 150 levels across topics ✅ Multiple solutions per level ✅ No account, progress saved locally ✅ Most of the M functions are implemented Try it: mgame.datameerkat.com #PowerQuery #MLanguage #PowerBI

@ganeshmdoifode But this feeling of ease only masks the problems that create it: 1) Ignorance of pitfalls and architectural errors 2) Ignorance of one's own solution 3) Uselessness of junior roles 4) Overlooking security errors ...

@tpnRel1 I agree, it makes life too easy. Only you know what you need to do to make it happen, Claude.

Hmm... I am experimenting with Claude a lot recently and it is interesting tool indeed. It generates a lot of security flaws in its generated code, but still... It can make your life much easier if you know what you are doing.

@SQLGene @igocrite

@igocrite Also, the cake is a lie. So.

What if you could run M and DAX in your browser? Well I've got an extremely minimal PoC working. You can edit the input CSV and edit the code that's run. Let me know what you think. Link below.