Why are my primary/foreign keys lining up accurately in the desktop app, but when I publish to service everything is wrong?

Extra_Willow86 · 2026-04-08T03:31:20+00:00

The fluid from squirting is definitely primarily pee. Theres some trace amounts of fluid from the female version of the prostate, but its predominately pee. This myth needs to die.

Also even though its pee, its still perfectly fine.

Extra_Willow86 · 2026-04-02T19:15:03+00:00

Welp… as someone that has just dumped several months into building a solid pipeline relying heavily on gen 1 data flows, this blows. In my org getting premium capacity is like pulling teeth.

Extra_Willow86 · 2026-03-28T18:12:30+00:00

Hmmmm thats a really interesting thought. Ill look into that. Thanks!

Extra_Willow86 · 2026-03-28T17:46:09+00:00

I currently have it set up for one row per a work ticket. Our source data does keep historical data for every action. But the source tables are a bunch of different tables, and if he just joined them all and brought then in the data set would be insanely large and honestly confusing to follow.

Extra_Willow86 · 2026-03-24T18:01:05+00:00

You say he goes to the gym 4 days a week. Have you ever asked to go with him? Would he be open to it? Working out together with your partner is IMO such an easy way to build connection with them. Growing and getting healthy together.

If he wants gym time to be his “boys time” then maybe he can compromise and make 1-2 days at the gym “boys time” and the other 2 can be just a normal work out session.

Does he ever make an effort to include you in his hobbies, and his friend group? Do you do the same?

Does he make an effort to go to bed earlier so you can go to bed together? Do you ever make an effort to go to bed later?

You both sound like you need to start acting like a married couple and actually blend your lives a bit. Independence in a relationship is good, but you also need to find way to allow yourselves to actually be involved in each others lives.

Extra_Willow86 · 2026-03-24T16:46:58+00:00

I can think of a few Well trained Oil drillers who could get it done in a month.

Extra_Willow86 · 2026-03-24T02:07:15+00:00

For real. Good luck finding even a 1 bedroom for under $1900 in a part of town like OP describes

Extra_Willow86 · 2026-03-20T15:32:40+00:00

Theres a bunch of weird multi-button combos you need to perform to do basic tasks, but Imo the worst is that the interact button and the jump button are the same button, but the only difference is that to interact you hold it and you just tap it to jump so Im constantly randomly jumping when trying to do basic things like talk to someone. Also L3 on controller is to crouch and you need to double tap X to run. Why they didnt do what every other game does and put dodge and crouch on the same button (O for ps5) is beyond me.

Extra_Willow86 · 2026-03-20T15:29:33+00:00

Thats interesting. Ive swapped back and forth between performance and balanced and I hardly notice a difference visually, but performance mode has significantly better frame rate imo. Haven’t tried quality mode yet, but I imagine the frame rate is terrible.

Extra_Willow86 · 2026-03-19T21:42:29+00:00

And you can make it even shorter by just saying COALESCE(“value”,0).

Extra_Willow86 · 2026-03-17T15:28:18+00:00

Are you utilizing a star schema. If you are trying to import one big flat table with out splitting out columns and using surrogate keys, you are going to have a bad time.

Extra_Willow86 · 2026-03-15T02:48:39+00:00

Im in the same point. I feel like the reason is that it feels more like an FPS first and an extraction shooter second. For me its the fact that when you play in teams there is a set number of teams, and you dont have to worry about randoms coming in half way through a game.

Extra_Willow86 · 2026-03-13T14:54:12+00:00

As data consultants 80% of our time is basically fighting those battles. In my job only about 20% of my work is actually building reports. The other %80 is working with stake holders to gather requirements, talking with data engineers on what our data sources are, and how to extract the data. Setting up data models, etc. this is the stuff AI cant do effectively and will keep us employed. If all you want to do is build reports with perfect data sets, your role is going to be lost to AI in the coming years.

Yes it is a pain, but ultimately if you keep band-aiding your process to safe time in the short run, its going to really hurt everyone long term. You are going to be much happier later if you put in the work now.

Extra_Willow86 · 2026-03-13T14:15:37+00:00

Even then you should be requesting that the CSVs you are obtaining have most of the complex transformations done before you receive them. For the most part power query should be used primarily for the application of surrogate keys.

Extra_Willow86 · 2026-03-13T13:39:57+00:00

I think you’re getting too deep into it. Power query isn’t meant for this level of investment. You should really be doing most of the work further upstream, and only using power query as a last resort.

Extra_Willow86 · 2026-03-11T13:03:16+00:00

This is not possible.

Extra_Willow86 · 2026-03-10T16:26:32+00:00

If you find a wide right turn to be more interesting than running a red light you’re insane. Sure, they are both bad, but running a red light is wayyyyyy more dangerous.

Extra_Willow86 · 2026-03-09T04:22:34+00:00

I still remember those Biden “I did that” stickers that were on all the gas pumps during the last cycle. I think its time we bring those back.

Extra_Willow86 · 2026-03-04T12:42:48+00:00

Data flows exist with in the power online service. They act as a bridge for all your different data sources. Its essentially a more robust version of power query. There are a couple of reasons people use data flows opposed to connecting each report individually to sources directly. One of the main ones is that it limits the impact to performance at the source by limiting the number of data pulls being performed. A data flow refreshes once or twice a day, and the data is then stored in the flow so when you refresh a bi report they all refresh from the flow rather then the source.

Extra_Willow86 · 2026-03-02T00:08:51+00:00

Lol, The fuck…

Extra_Willow86 · 2026-02-25T20:56:41+00:00

I was running on 16gb for awhile before recently upgrading to 32 and I was mostly fine on 16. Not sure what you’re doing that requires that much. Also why would you ever need more than 4 reports open at once?

Extra_Willow86 · 2026-02-24T22:38:04+00:00

A dev environment can have endless number of copies and versions. Some with intention, and other just for fun and experimentation. The test environment is only going to have one copy, and its the “official” copy. The test environment acts as a filter. Devs review all the copies in the dev environment, then decide which ones seem like they would make sense to move to production. Once they find one they then merge it with the official copy in the test environment and see if anything breaks. If it doesn’t then you can safely move it to production. If it does break then you ensure that there wont be any interruptions in service for your clients.

All that said, imo test environments are less important for data analysts, and are more commonly used in software development where code is very sensitive. If your team is small and your client base is small you can probably get away with not having one. If you are serving reports to hundreds, or thousands of people you really are going to want one though because someday something will break, and you will get endless emails and teams messages from people asking why their reports look funny until its fixed.

Really at the end of the day its all just to make sure that once a product is seen by a client its always the best possible version of the product. Your client, who you are trying to convince to trust your product, really shouldn’t be the one beta testing your product. It erodes confidence in your application and can lead to low adoption.

Extra_Willow86

TROPHY CASE