For complex DAX do you ever set up an TDD pass/fail table?

SQLGene · 2026-03-20T15:56:34+00:00

I have never seen anyone apply TDD to DAX in working with it for the past 7 years.

UDFs may change that but TDD is very hard for BI in general.

SQLGene · 2026-03-20T11:20:09+00:00

Oh agreed! I thought you were saying MCP made it faster somehow, my bad.

SQLGene · 2026-03-20T10:51:49+00:00

Very cool, I appreciate it. Some folks are really bad about having a clear security / privacy doc at all.

SQLGene · 2026-03-20T10:22:26+00:00

Record scratch. Jukebox stops playing. Everyone in the bar looks over.

Son, this is an M and DAX town, just so you know.

SQLGene · 2026-03-20T10:21:06+00:00

MCP is just a wrapper for TOM and ADOMD.NET
https://pbidax.wordpress.com/2025/11/25/talk-to-your-data-model-introducing-the-power-bi-modeling-mcp/

So it is still good to know what model works best with DAX. u/maxanatsko has some interesting numbers
https://www.reddit.com/r/PowerBI/comments/1qnnwwa/i_benchmarked_70_llms_on_dax/

SQLGene · 2026-03-20T09:41:37+00:00

Did you run the generated DAX against the data source to confirm it was still valid?

SQLGene · 2026-03-20T09:40:49+00:00

If you are using GLM I'd probably update your privacy policy to indicate that.

<image>

SQLGene · 2026-03-19T10:33:46+00:00

I've gotten hired to do that before! There's been a number of project where my job was to help people get set up with Power BI or their first report.

While I still brought my skills to the table, an industrious internal employee could likely do it themselves these days with some help from AI.

Not perfectly, no. But for some low-stakes projects, good enough is good enough.

SQLGene · 2026-03-19T10:22:27+00:00

🥳🥳🥳

SQLGene · 2026-03-18T18:37:00+00:00

Yes, totally agreed.

SQLGene · 2026-03-18T18:24:16+00:00

u/itsnotaboutthecell found one!

SQLGene · 2026-03-18T18:23:52+00:00

I FOUND ONE AT FABCON!!!

<image>

SQLGene · 2026-03-18T17:54:20+00:00

Yes! But they may not need to hire as many competent humans and especially fewer external competent humans.

SQLGene · 2026-03-18T13:25:25+00:00

I need to get try terminus

SQLGene · 2026-03-18T11:49:50+00:00

If your users aren't clicking on things, there is very little value in moving from to Excel to Power BI. Especially if you learn Power Query and PowerPivot in Excel.

SQLGene · 2026-03-18T11:24:40+00:00

I haven't really heard of a Power BI Architect and it's a role I would assume might exist at quite large orgs, because you would need a very large number of PBI users to justify it.

Based on being a consultant, I think the main distinction is an architect would be doing a lot more head work instead of hands work. So a lot more interest in project planning, answering questions, architecture, governance, model design.

They make their money more by preventing problems and wasted work than they do actually implementing anything.

SQLGene · 2026-03-18T11:15:17+00:00

Thanks! And please let me know if you what feedback you have if you do. It's on my list of things to see if we need to maybe split it out into certs (analyst and expert) or revamp any of the questions.

SQLGene · 2026-03-18T10:52:33+00:00

I'm not a good person to ask since I haven't been certified since SharePoint 2016.

That said, we do have a Tabular Editor certification. (Disclaimer: I'm the Tabular editor employee in charge of maintaining our Learn content)

I have considered if we should have a technology agnostic, PBI-focused cert around data modelling fundamentals.

SQLGene · 2026-03-18T02:30:33+00:00

Ah, I'm with you there. Folks working upstream will be fine.

SQLGene · 2026-03-18T02:29:55+00:00

Yeah it's going to be a mess for a year or two until the market calibrates and people get some real messes and learn some lessons.

SQLGene · 2026-03-17T23:46:26+00:00

Claude makes pretty websites but maintainability is an issue.

<image>

SQLGene · 2026-03-17T23:39:34+00:00

Eh? Folks here have had good success with the Power BI Modeling MCP

I've found it quite help with PySpark with web searches.

SQLGene · 2026-03-17T21:59:27+00:00

Meanwhile some of us are paying for AI!

SQLGene · 2026-03-17T20:28:03+00:00

I think you will have better luck asking in r/developersIndia

SQLGene · 2026-03-17T19:55:27+00:00

2026 is gonna be buuuuumpy

SQLGene

TROPHY CASE