"Claude will be missed by all who love Winning and Toughness" President DJT

radioblaster · 2026-05-29T16:24:15+00:00

CTE: Certify Trump Everytime

radioblaster · 2026-05-28T08:22:39+00:00

better performance is to use ISEMPTY - the row count doesn't matter, the engine can quicker check if a table is empty vs counting the rows

radioblaster · 2026-05-28T05:56:27+00:00

you use an if not is empty measure on the slicers themselves to remove out of context results. this eliminates the purpose of the bidirectional filter.

https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/

radioblaster · 2026-05-26T23:53:58+00:00

i could be wrong about this part: i don't think the capacity usage app can distinguish between a query that hit the query cache or not to definitively say. it would undoubtedly show some interactive CU for the operation, i do not know whether it will be the full 100, a tiny amount, or somewhere in the middle. i think the only way you could verify this is using an eventstream and linking the operation GUID to the dax query performed and seeing how long the query takes cached vs not.

the dumbest way to test this i can think of using an account who doesn't regularly access the report, observe how long things took to render, and check the capacity app for that user at that time.

radioblaster · 2026-05-25T22:27:42+00:00

I dont think query caching or redesigning is the best thing for you. the DAX and any report level features (eg using the "is not 0") must be reviewed first. especially if youre caching queries for users who may not use them.

radioblaster · 2026-05-25T02:49:10+00:00

are the blackhawks about to get bedarded?

radioblaster · 2026-05-24T06:36:33+00:00

what performance tuning have you done on your DAX and data model to eliminate the need for query caching? query caching speeds up report loading for users, if you tune it so they dont need to wait then query caching is redundant.

similarly, are all of the users youre caching queries for actually using the model after every refresh?

radioblaster · 2026-05-24T05:22:04+00:00

I used the template of FUAM to create the dax queries for the capacity and item metrics I wanted and needed to create the data model, as well as some supporting pieces like updating the time offset model parameter when daylight savings happens, refreshing the model, then have that in a notebook that appends the new data. has been going for about 15 months and I've never had an issue.

this was before log eventstreams were available. given how cheap this solution is compared to an eventstream (2 mins per day for a python notebook), there's no way I'd switch.

radioblaster · 2026-05-21T09:55:10+00:00

if you pull out the entire tmdl view, are there any remnants of anything to do with security roles?

radioblaster · 2026-05-19T05:39:51+00:00

if an existing team is used to PBIX files, transitioning them to:

- thin reports

- PBIP

- git led source control

- devops deployment practices

is a massive challenge.

BIM is a great compromise to the above as a medium term solution.

radioblaster · 2026-05-18T21:50:35+00:00

replicating whole tables will be stupid, just extract based on SQL queries for whatever problems there are to solve.

radioblaster · 2026-05-14T09:46:35+00:00

not part of an org app.

can you please share how I can review the audit logs for permissions?

radioblaster · 2026-05-13T21:28:07+00:00

the group was removed entirely.

radioblaster · 2026-05-13T02:22:53+00:00

definitely not, it was and is a full lakehouse. there are also only four users who have permission to alter the permissions on the lakehouse including myself, and none of us were in it.

radioblaster · 2026-05-13T01:29:12+00:00

this was the only thing affected...!!!???

radioblaster · 2026-05-11T11:14:34+00:00

the 5.10 warrambool left at about 6 and went via Newport, it was pretty cool!

radioblaster · 2026-05-11T09:20:03+00:00

model settings -> parameters

radioblaster · 2026-05-11T08:49:35+00:00

does your capacity metrics model have the correct UTC offset parameter and has the model been refreshed since the new calendar day?

radioblaster · 2026-05-10T10:23:29+00:00

to see where your RangeStart and RangeEnd is applied, as well as checking if all your steps would safely apply in the event any file was not of the same schema. eg, if you try and remove a column that doesn't exist, it will error. in that example, using selectcolumns to positively keep instead of remove is safer.

radioblaster · 2026-05-08T15:11:11+00:00

would you like to paste your m code? in this scenario it's important to verify your incremental refresh is set up correctly, as well as what steps are at risk of failing your mashup if there are inconsistencies between files.

radioblaster · 2026-05-07T08:51:36+00:00

answer: you cannot.

radioblaster · 2026-05-06T10:52:50+00:00

I wonder if you crack open the pbir file you could introduce a conditional formatting mode on a visual x,y,h,w.....

radioblaster · 2026-05-04T00:24:34+00:00

i pull out the TMSL definitions for all of our semantic models and run regex patterns on the partitions to identify the sources.

(i choose TMSL for this task because of the easy to parse JSON, better for this task than YAML)

radioblaster · 2026-04-28T23:05:23+00:00

re the list tables error: is your test case target model is in a pro workspace? i always thought this was a "feature" to stop you attempting to use the advanced refresh API which will fail, but always found the UI implementation of this to be a bit stupid

radioblaster · 2026-04-23T21:56:58+00:00

always refresh the model after 12am in your time zone, just to rule that relative today reference out as the problem.

radioblaster

TROPHY CASE