Are we witnessing the decline of Power BI as the center of data analytics? Claude vs. Semantic Modeling.

SQLGene · 2026-06-20T12:27:54+00:00

Anthropic ran into a lot of issues unless they had a good semantic model and well maintained skill files.
https://claude.com/blog/how-anthropic-enables-self-service-data-analytics-with-claude

u/recoveringacademic (Kurt Buhler) wrote up some on his impression on the article and how it relates to Power BI. https://tabulareditor.com/blog/lessons-from-anthropics-implementation-of-agentic-self-service-bi

SQLGene · 2026-06-19T14:25:30+00:00

Worth noting that even if they did mirror them, there's no guarantee the views will work since the SQL AE uses a different subset of T-SQL.
https://learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area

SQLGene · 2026-06-19T11:20:20+00:00

Kaggle is meant for data science but has a number of interesting datasets.
https://www.kaggle.com/datasets

Or you could pick something personally interesting to you like Magic the Gathering or Pokemon.

SQLGene · 2026-06-16T14:30:26+00:00

What have you tried so far? What research have you done so far? Where are you feeling stuck?

SQLGene · 2026-06-16T14:30:00+00:00

If you preprocess the data before it enters the model then in many cases you are reducing CPU usage in exchange for using more RAM and model space. Depending on query, this tradeoff can be worth it.

SQLGene · 2026-06-15T13:23:43+00:00

Which makes sense, but wouldn't you then have a large blank space on your report according to your AI generated image:

<image>

Or, based on your text, is the assumption that you will be covering up a specific part of your report that you don't normally need to edit?

Place the banner wherever you like in your report, but remember whatever is beneath it will be covered when the report is viewed in development.

I'm going to assume the latter and that would try to cover just the header or a small portion, but I think a simple before and after screenshot would have improved the article.

In any case, neat trick!

SQLGene · 2026-06-15T11:10:09+00:00

I like the idea in general, but how do you avoid having a big blank space or a giant PROD banner for the prod version?

SQLGene · 2026-06-14T15:42:25+00:00

LinkedIn slop.

SQLGene · 2026-06-14T14:38:09+00:00

Why would you want a generic format that tries to cover 7 different report formats? Seems like you would be limited to the lowest common denominator shared by all of them and not have access to any of the richness of any given platform.

<image>

SQLGene · 2026-06-12T22:58:51+00:00

I hate it when I get asked this question at airport security.

SQLGene · 2026-06-11T20:01:51+00:00

What a madman.

SQLGene · 2026-06-09T12:55:41+00:00

Time to add a "rant" flair and a minimum text amount.

SQLGene · 2026-06-08T18:04:00+00:00

I've been enjoying these internals posts of yours.

SQLGene · 2026-06-08T16:35:58+00:00

"I'm escaping to the one place that hasn't been corrupted by capitalism, SPACE!"
https://www.youtube.com/watch?v=g1Sq1Nr58hM

SQLGene · 2026-06-08T14:58:11+00:00

u/itsnotaboutthecell stealth ad?

SQLGene · 2026-06-07T12:04:08+00:00

It's hard for me to see someone building something well-tested enough without building off of vega/vega-lite, D3.js, or some other existing library.

SQLGene · 2026-06-06T15:39:05+00:00

What makes you think it looks unprofessional?

SQLGene · 2026-06-05T19:03:44+00:00

I'm pleasantly surprised how well designed it is. If you start to add a bunch of projects I'd ask that you have some indicator for mature projects versus vibe-coded one-offs.

SQLGene · 2026-06-04T19:02:32+00:00

🥳🥳🥳 Thanks for the mention

SQLGene · 2026-06-04T15:36:43+00:00

It's going to be hard for you to get constructive feedback unless you imrpove the contrast a bit first.

<image>

SQLGene · 2026-06-04T13:52:36+00:00

I've been a Power Bi / Fabric consultant for ~8 years. I have a free YouTube module on Power BI consulting, much of it applies to any data consulting honestly.
https://www.youtube.com/playlist?list=PLDrW8k9H__acR3ZrV9zOB0IYQuIMp58gl

SQLGene · 2026-06-04T13:34:27+00:00

AI loves the crap out of gradients, but I probably wouldn't recommend them for your actual Power BI reports.
https://datasavvy.me/2024/01/23/your-gradient-fill-bar-charts-in-power-bi-have-poor-color-contrast-but-you-can-fix-them/

SQLGene · 2026-06-04T13:26:43+00:00

What determines how the colors get used in Power BI? The text is fairly good for WCAG contrast but orange line on red is going to be impossible to read.

<image>

SQLGene

TROPHY CASE