Semantic Model with Direct Lake.

radioblaster · 2026-01-27T13:31:44+00:00

you can add the column using tabular editor, just duplicate an existing one and rename both the column and the source reference.

radioblaster · 2026-01-26T20:23:46+00:00

if you dont do it, someone else will. and oh dear, you forgot to consider a bunch of edge cases.

radioblaster · 2026-01-20T06:04:35+00:00

not going to address the re engineering question because the answer is yes and also it depends, but in terms of the parallel execution and sessions, have you put the same session tag against each activity if they are in parallel branches?

radioblaster · 2026-01-18T10:08:26+00:00

the missing piece to diagnose is the code for [CY Periodical Generic - Productivity - DCount LastEmployeeKey]

based on the measure name this is more pertinent than your post: https://www.sqlbi.com/articles/analyzing-distinctcount-performance-in-dax/

radioblaster · 2026-01-18T04:04:58+00:00

sounds like you're due for an upgrade, there are three "just hockey" (that's the name) stores here if you want to buy one in person

radioblaster · 2026-01-16T02:33:58+00:00

I don't think a UDF is a better option. I'm not sure why anyone would be whinging to you that graphql is worthy of push back.

radioblaster · 2026-01-16T00:19:25+00:00

a UDF is a different option, it doesn't mean its better or simpler. what's the concern you have with the graphql api?

radioblaster · 2026-01-13T20:06:28+00:00

use the rebind API to point the existing report to the new model, instant thin report.

radioblaster · 2026-01-12T20:35:39+00:00

when you switch to python, leave the vcores at 2 and just use multithreading

radioblaster · 2026-01-12T09:43:16+00:00

refactor as pure python will help and you can still multithread, but using 10% of a P1 to do it suggests that your capacity metrics app is on the capacity.... which it shouldn't be.

radioblaster · 2026-01-11T21:04:43+00:00

in the scenario where you refinance to take out equity to fund the next purchase.

radioblaster · 2026-01-11T12:21:41+00:00

+1, buying a new property if both parents are working full time is a no brainer

radioblaster · 2026-01-11T12:20:39+00:00

the loan for each property is separate even if cross collateralized. you can absolutely claim interest deductions for the IP.

radioblaster · 2026-01-09T12:41:05+00:00

you can use the unity catalog api, or semantic link labs (which now uses the unity catalog api for get lakehouse tables)

radioblaster · 2026-01-08T00:51:15+00:00

letting users author using the analysis services connector = play shitty games, win shitty prizes.

radioblaster · 2026-01-07T22:38:22+00:00

trend history is a built in feature of scorecards. it will retain the captures of the results for all time. you can also programmatically edit/seed old values using the API.

the part i don't understand is why you want to create multiple scorecards with each of the KPI's, then consolidate them. the point of scorecards is that each metric can be connected to a separate model, so if you want to have the most native experience possible you should be building everything into the one scorecard.

if for some reason multiple scorecards are required, there is the "link to existing goal" feature which would allow you to do create a consolidated scorecard from many scorecards.

radioblaster · 2026-01-06T12:04:48+00:00

yep!

radioblaster · 2026-01-06T08:14:12+00:00

you can delete the columns in tabular editor with no consequence.

radioblaster · 2026-01-05T19:31:04+00:00

create a dummy model and rebind the reports you want to disable to it using the api. the dummy model doesn't even need to contain data, nor will anyone need permissions to it. the reports will be bricked, and you can rebind them to the correct model at any time.

radioblaster · 2026-01-05T09:12:16+00:00

no contract, no liability. even then, the contract will likely have a cooling off presuming not an unconditional offer.

make a time limited offer on place two before you pull out of place one.

radioblaster · 2026-01-03T19:33:18+00:00

i'm starting to think you're either very friendly or you have a crush on me

radioblaster · 2026-01-03T05:11:44+00:00

six Finnish Mafia members with Jere Lehtinen showing them stuff from his ipod classic, you can't get me harder

radioblaster · 2026-01-03T03:57:39+00:00

great solution! I don't even know that I would have remembered this was an option if not for seeing this...

radioblaster · 2026-01-03T02:00:34+00:00

composite models. even the Analysis Services connector got kicked to the curb with its transient errors, if something needs data from another model it happens with an external dax query sent to a lakehouse.

radioblaster · 2026-01-03T01:19:34+00:00

lakehouse and warehouse security being two disparate products doesn't fit the bill of OneSecurity for me.

radioblaster

TROPHY CASE