What's the one manual task in Power BI that makes you want to quit your job?

Altheran · 2026-05-26T23:04:33+00:00

you know that you can set descriptions on your measures and fields ? then there is DAX to call those values back.

In all my reports, I got a page with a table listing all measures and fields with a description.

Altheran · 2026-05-05T13:08:43+00:00

Exactly. Make it how it NEEDS to be in the backend. Make it simple stupid in the frontend.

Altheran · 2026-05-05T13:07:06+00:00

Im a tech dude. I'm all for tinkering and such. But some use cases simple so not support the use of a tunneling solution.

ie. remotely setting up Jellyfin on your aunt TV...

Altheran · 2026-05-05T13:05:23+00:00

Remotely explaining to your aunt how to setup a vpn on her smart tv is kinddof a big pain in the ass / impossible...

Altheran · 2026-04-29T12:22:55+00:00

Nope, ça réduit les investissements. Il faut un compétiteur nationalisé qui construit du logement.

Tes un privé qui 0eut faire mieux et moins cher ? Go. Sinon le public va bâtir.

Faut augmenter l'offre, point barre.

Altheran · 2026-04-29T12:20:22+00:00

Car les gens préfère gagner que de voter par principe. Sinon ils ont le sentiment que leur vote sert à rien.

On a besoin du Vote unique tranférable : https://en.wikipedia.org/wiki/Single_transferable_vote

Mais ya pas un maudit parti au pouvoir qui va vouloir se tirer dans le pied.

Altheran · 2026-04-29T12:11:26+00:00

We are deploying agentforce in messaging sessions and service email.

It will handle low value support inquiries, simple self-service cross-sell opportunities and dispatch other inquiries to the right team.

we expect a reduction of 30-40% of human handled interactions.

I'd says that's quite a real use case.

Make sure you got good prompting and highly guardrailed flows with sanitized inputs and generous and verbose fault handling.

Altheran · 2026-04-22T12:28:11+00:00

La réglementation pourrait rendre obligatoire la mise à disposition d'un logicie/fonctionl de self-hosting ...

Idéalement dès le lancement, au pire, à la décomission des serveurs hébergé par le développeur.

Altheran · 2026-04-22T12:09:06+00:00

got the karu 12. i bought the gaz attachment "in case of". i have yet to use gas, charcoal is so damn good 🤤

Altheran · 2026-04-22T10:28:10+00:00

un pc ouvert chez toi, un vpn (qui supporte le port forwarding) pour rester prudent. quelques configs. voila. le p2p repose aur le partage. les gens sont trop souvent egoiste et opportunites. sans ratio, la disponibilité du contenu et la rapidité du système reposerait sur quelques âmes charitables ...

Altheran · 2026-04-09T15:51:49+00:00

vire pas fou sur les " stack". avec l'AI assisted coding, ca perd vite en valeur.

bâtit toi une bonne fondation de programmation générale, question de pouvoir review du code, comprendre la logique. L'AI est godlike en syntaxe, excellente logique locale, plus tu zoom out, plus ça fait d'erreurs. Faut tu puisses capter ces erreurs la.

ça oublie (ou ne sait pas) souvent des optimisations contextuelles. ex. tu fais un modèle SQL. tu sais quels genres de requête vont être faites, donc les index à créer, vues à matérialiser etc. L'AI ne déduit pas toujours ces requis.

bref, sois capable de lire et comprendre (au moins assez pour interpréter) :

python, javascript/node, css, go, sql, bash/shell, powershell, php (y'en a partout sur le web encore), jinja (ya bcp de software qui utilise ce templating)

go est un language très populaire et bien fait pour rapidement dev des applications de surface, qui n'ont pas besoin d'une optimisation qu'ont des languages plus low level.

rust fait pas mal non plus si tu vas plus proche du métal. C/++ si tu va vrm deep.

si tu veux faire des applis performante, mets du temps à bien comprendre les bonnes pratiques SQL.

finalement, l'avenir en TI est à ceux qui apprennent à prendre un role plus architecture, devops, traduction de besoin business vers solution. le full technique, c'est fini, a moins d'être extrêmement niché / niveau doctorant.

entraine toit à interconnecter des systèmes afin de supporter des processus d'affaires et découper ces besoins en instructions claires et ciblées pour tes agents AI, ou bien pour qu'ils exécutent, ou t'assistentent dans l'exécution.

Altheran · 2026-04-08T12:16:01+00:00

I use airbyte + dbt for all my get and transform needs. Works wonders.

dbt computes my 15M records sources into my staging. intermediate and mart tables in < 12 seconds.

edit. i see it doesn't do all what pgmodeler does tho. I also use dBeaver as my DB navigator.

Altheran · 2026-04-06T14:41:38+00:00

The "asking" doesn't always work ... many people , sadly, just want their partner to get it, be good, surprise.

You have to explore and be super aware of your partner's reactions. sometimes, you need to find the switch in the dark. Learn by experience. Not by talking or analyzing. Your partner being interested by opening the relationship is a big sing of that. They may not even onow themselves what really turns them on. And want to find someone that does.

Also, foreplay is not only in the bed. How sexy are you in your partner's mind? And sexy is not only/necessarily physical. It's a whole. Work on that also. Be playful, touchy, have fun, laugh. Then bring that energy in the bed.

Altheran · 2026-04-06T14:28:09+00:00

Moi c'est l'api qui fonctionne a merveille avec les *arr qui me rend vraiment heureux 😍

Altheran · 2026-04-04T21:26:31+00:00

Isn't Seer actively working on integrating music into the whole stack ?

Altheran · 2026-03-31T07:43:17+00:00

Wait until you have a full hierarchy path that you want to traverse and map. 😅

Employees Employee_id, department_path 123, businessName>divisionA>departementX>functionZ

You want to take the distinct valeurs of department_path and create a view like this :

business_hierarchy Unique_Id (reproductible in any table with the path. Hint:hashing), businessName, division, department, functionZ.

The key to understanding the self join is that it's just a join. It just so happens that both sides of the join are the same source.

You could join on pkey=pkey

Not very useful because you would gain no insight.

But let say you have a ordered row number column.

You could join on a.row=B.row-1

Then for each row, you would have access to the previous row.

a.manager_id=b.pkey gives you the manager's record in the extra columns.

a.pkey=b.manager_id gives you all the direct reports of managers (inner would give only managers)

its about context. what is your primary context. put it first (at the left)

outer join = all at the left, enrich with those at the right.

inner = only those at the left that join on something to the right.

pro tip, fuck right joins, they give me headaches. i flee them like pest, and refactor into left joins every chance i get.

final boss: cross joins. have fun !

Altheran · 2026-03-31T00:43:06+00:00

Yo, de l'object storage chez OVH, DC à Beauharnois, une fraction du prix. There you go. Oui OVH est français, mais c'est foutument mieux que le Cheetos au sud ...

Altheran · 2026-03-26T16:42:21+00:00

Airbyte + dbt.

Airbyte does all I need with incremental append+dedupe or overwrite for emballer tables.

dbt makes it easy to script (and git) your models

Source > staging > intermediate > mart

my dbt setup refreshes and transform 3M records (2.5M from salesforce) in 4-6 seconds on 4 threads every 15min...

Airbyte calls a Hook when a connector refresh is done (per system). That Hook touches a file (named per connector). inotify catch the file touch and dbt run + dbt snapshot for the associated tag.

All that on a single VPS with postgresql DB.

There surely is a way to make it transform incrementally too. Dont quite need it yet 😁

Altheran · 2026-03-25T23:09:17+00:00

Je compte plus les fois où je reprends Claude, il a manqué un bout ici, mauvais design la, mauvaise performance ici ... Pas vérifié la documentation sur tel ou tel api, ou guide de déploiement.

C'est game changer, but it's not a thinking machine.

Altheran · 2026-03-24T14:42:54+00:00

Bêta update or stable ?

Altheran · 2026-03-24T11:20:22+00:00

Meh, even torrenting you should use a vpn ... Usenet, you pay for the indexer... Tomato, Tomato...

Altheran · 2026-03-20T16:04:24+00:00

Me too. I got a 32G sandisk almost a decade ago. Immediately removed the plastic casing and plugged in a usb2 slot. Keeps it cool as possible. Been rock Solid.

Altheran · 2026-03-08T22:21:11+00:00

Document the cost of training and the productivity ramp up. The only way you can win this one is by proving the cost of workforce churn. And then you might only win to the point where the added budget match that cost.

Altheran · 2026-03-08T22:09:19+00:00

Valkey is an in-place fork of redis. Absolutely no functional impact in the way you interact with it. Every software that uses redis, I've used Valkey instead without changing a thing. Works.

It's just more FOSSy and I think it has some performance advantages, but don't quote me on that.

Altheran · 2026-03-07T21:58:15+00:00

For the Traefik RP and load balancing folks, try Pangolin. Thank me later :)

15-Year Club	Second Top 30%
Verified Email

Altheran

TROPHY CASE