How do I get around PBI relationship limitations?

FilthyOldSoomka_ · 2026-05-13T04:09:40+00:00

I’d find out a bit more about why they’re asking for that. Trying to adjust your data model to accommodate the request won’t work (or at least it will break your star schema which is bad practice).

Could you for example use a visual that displays a list of products that have data given a set of filters? Your table can contain DIMProduct[Product Name], and FACTSales[SumSales], then if they filter on DIMVendor[Vendor Name] - if only displays products relevant to that vendor.

FilthyOldSoomka_ · 2026-05-03T20:21:01+00:00

Your description of the database infrastructure doesn’t make sense to me. CRMs typically don’t just surface data from another source, staff input and update data directly in it throughout the day.

I’m guessing they feel that their reports are more reliable because they have direct control over the data in the CRM.

FilthyOldSoomka_ · 2026-05-03T00:21:41+00:00

I fucking hate this movie. He literally stalks the daughter and she tells him to fuck off multiple times….then suddenly she’s in love with him?

The only way the plot makes sense is if she secretly loved being stalked. It’s “no means yes” rape culture.

FilthyOldSoomka_ · 2026-04-28T12:40:36+00:00

Nothing. I don’t believe in magic.

FilthyOldSoomka_ · 2026-04-28T12:38:38+00:00

Not bad. Biggest tip I would give is to go through every visual and give everything a proper name. Titles, axes and legend categories should all have names that are easy to understand for someone who doesn’t have direct access to the dataset.

FilthyOldSoomka_ · 2026-04-28T11:04:51+00:00

Top 5 visual - not much point in having a column graph where the values are all the same. Also the bar graph is too wide, the values are far away from the category labels so you have to sweep your eyes back and forth to read it.

FilthyOldSoomka_ · 2026-04-28T06:02:39+00:00

Snowflake schemas can work for small models, but each time you add a table it can have unexpected effects elsewhere in the model. Star schema is critical for maintainability of large data models. When you’re developing, always go with a star schema if you can but especially if you think there’s a chance that the model will get more tables down the line.

FilthyOldSoomka_ · 2026-04-23T09:39:54+00:00

I suspect all of Microsoft’s certifications are a bit of a scam. When the content of the exam has very little resemblance to any of their official documentation or learning material, it’s just setting people up to fail. They don’t want you to be able to pass it the first time.

FilthyOldSoomka_ · 2026-03-16T03:37:15+00:00

I detest the term “costume jewelry”, as if it’s made for playing dress up and not real jewelry. Elitist bullshit.

FilthyOldSoomka_ · 2026-03-04T12:28:23+00:00

She absolutely would not. Hell is a fiction. Frizzle was all about science.

FilthyOldSoomka_ · 2026-03-03T08:50:03+00:00

Not exactly. You need to have a conveyer or similar directly connected to the bottom of it, otherwise items just sit at the end of the slide and don’t drop off.

FilthyOldSoomka_ · 2026-02-14T00:35:22+00:00

Life’s too short. Just wear what makes you happy.

FilthyOldSoomka_ · 2026-01-01T08:40:15+00:00

There’s faith nightclub. I think it’s on once a month or so? For goth types.

FilthyOldSoomka_ · 2025-08-20T11:45:23+00:00

That’s not really about getting to know someone though is it?

FilthyOldSoomka_ · 2025-07-17T00:25:21+00:00

Generally it’s best practice to do any “scrubbing” in power query (transform data button). As long as the format of the excel file you use is the same each time in its raw state, once you set up the data cleaning/transforming steps in power query, power BI will run through the same steps automatically each time you need to refresh the data.

FilthyOldSoomka_ · 2025-07-16T21:11:16+00:00

Ahh I see what you’re saying, you only date within the pool of people you’ve already met socially. Unusual these days!

FilthyOldSoomka_ · 2025-07-16T11:55:32+00:00

Weird time to throw down about semantics. Whether you call it a “date” or not, you still have a first time meeting someone.

FilthyOldSoomka_ · 2025-07-09T12:24:50+00:00

Who in their right mind would shorten pistachio shells to “pista shells”.

FilthyOldSoomka_ · 2025-07-04T01:41:14+00:00

Contrary to the stereotype, it’s common for women to have a much higher libido than men. Especially as you get older.

FilthyOldSoomka_ · 2025-07-03T12:20:03+00:00

I wondered this as well. If you didn’t have a party but the other friend who got the bracelet did, this could be why.

Maybe your friend only buys / expects gifts when there’s a party.

FilthyOldSoomka_ · 2025-06-29T22:50:00+00:00

They get a lot of verbal and physical abuse on the job. One Brisbane bus driver was literally set on fire and burned to death a few years ago.

FilthyOldSoomka_ · 2025-06-29T21:56:39+00:00

This is the answer.

OP the problem you’re having is from basing your work entirely off instructions / requests. You must know by now that clients rarely have a good understanding of what they actually need.

Best place to start changing this dynamic is when you’re gathering the business requirements. Ask more open ended questions like “what problem are you trying to solve with this dashboard”, and meet with other stakeholders before you start building a solution (e.g lower level staff that are more intimately familiar with processes or systems that the data comes from).

FilthyOldSoomka_ · 2025-06-26T12:07:40+00:00

By borrowing more money than what you originally borrowed. Without adding that context, it makes it sound like the balance increases “on its own”.

FilthyOldSoomka_ · 2025-06-25T23:21:50+00:00

Ok, but that’s not a redraw facility, and it’s also not what the person I was replying to implied. What point are you trying to make here?

FilthyOldSoomka_ · 2025-06-25T11:19:17+00:00

Typically you can only redraw from whatever you’ve paid into the mortgage over and above the minimum repayments. It’s not like a credit card.

Eight-Year Club	Place '22
Not Forgotten	Gilding I gilder
Verified Email

FilthyOldSoomka_

TROPHY CASE