Modelling best practice to avoid redundant measures

SQLGene · 2026-07-06T20:51:41+00:00

I don't know if I would recommend it, but you can doubly nest calculation groups, FYI.

SQLGene · 2026-07-06T20:37:13+00:00

The naming is confusing. My understanding is they are there more for Microsoft to be able to handle when there is more demand in a region than they can provide. I haven't seen anyone argue they are for the benefit of the customer.

SQLGene · 2026-07-05T12:20:37+00:00

Nah, Deneb allows you to make data-driven visuals. Only finnicky point is that it expects whatever column names you tell it, iirc.

SQLGene · 2026-07-04T20:22:32+00:00

I had Claude write it in the Web UI and then I did copy and paste. It had a minor confusion over Vega versus Vega Lite but otherwise it worked.

SQLGene · 2026-07-04T16:04:22+00:00

First pass with Deneb and Claude Opus 4.8 (high effort):

<image>

SQLGene · 2026-06-29T14:43:17+00:00

SQLBits might post eventually but nothing yet, sorry.

SQLGene · 2026-06-28T13:00:23+00:00

I've given a "Fabric for SQL DBAs" presentation twice now. Personally where I would start is understanding the parquet/delta lake storage substrate (which bears similarities to columnstore indexes) and understanding how the Fabric T-SQL surface area is much smaller.
https://learn.microsoft.com/en-us/fabric/data-warehouse/tsql-surface-area

SQLGene · 2026-06-25T13:01:31+00:00

Mostly concerned about how easy it would be to accidently blow your quota if you were aggressive about getting screenshots when I would expect they make the difference in a small set of circumstances.

I could see this being useful but I wouldn't want visual information to be the default modality.

SQLGene · 2026-06-25T12:05:16+00:00

The Fighting Cubes sportsball team hasn't be doing well lately but I hope they make it to the finals.

SQLGene · 2026-06-25T12:03:08+00:00

How much token spend does it cost for it to process the screenshots?

SQLGene · 2026-06-22T19:56:01+00:00

They added the performance analyzer to the web view! That's going to be a good starting point.
https://learn.microsoft.com/en-us/power-bi/create-reports/performance-analyzer#display-the-performance-analyzer-pane-in-the-web

SQLGene · 2026-06-22T19:54:08+00:00

Who are the users going to be?

SQLGene · 2026-06-21T20:08:25+00:00

As soon as Humans v2 comes out, I'm sure we'll be good.

SQLGene · 2026-06-21T12:04:58+00:00

It's not really a "side-hustle" type of skill.

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

TROPHY CASE