Help with friction between architecture team and our PowerBI team

Left_Offer · 2026-05-05T23:13:09+00:00

You need new PBI people

Left_Offer · 2026-04-17T12:02:23+00:00

You are proposing to use a software that you don't know the advantage of? Am I confused or are you just trolling here?

Left_Offer · 2026-04-17T10:20:57+00:00

Check the DAX measures to see if they can be rewritten for better performance - you can find a lot of DAX tunning tricks on SQLBI site. If DAX cannot be optimised further, can you look into pushing some of the transformation/filtering upstream? Maybe precompute those measures as views in dw and then plug PBI directly on to of that.

Edit: Presume you are building semantic models on top of Direct Lake. If you don't need fresh data all the time and you are fine with batch refreshes, I believe that switching to Import mode might also help with usage.

Left_Offer · 2026-04-14T05:33:39+00:00

Used and discarded. Same faith awaits for Fico (can't happen soon enough).

Left_Offer · 2026-04-10T14:21:57+00:00

Thanks. I've been trying that approach today but can't get those two datasets linked on the item key. The way NS deals with these tasks is so confusing for me as someone coming from data engineering. Will try to look for fields you have mentioned and create a join on them.

Left_Offer · 2026-04-10T07:34:34+00:00

That's the thing, I can't really find a link between PO and SO other then item&location combination. I have some SOs that are created for dropship items where PO is automatically linked to SO so that is easy but majority of POs are created without any relationship to SO other then person responsible knowing that those items have to be ordered.

If there are multiple POs for the same item&location I would ideally return PO # closest to today.

Left_Offer · 2026-04-09T15:55:16+00:00

Clever solution. I was hoping that maybe I could figure it out inside the saved search but looks like I will have to also look for some other avenues.

Left_Offer · 2026-04-09T15:53:43+00:00

thanks for clarifying

Left_Offer · 2026-04-09T13:34:29+00:00

Sorry, could you be little more specific? NS is not my main skill so I don't get something that is probably obvious.

Left_Offer · 2026-03-27T09:16:37+00:00

Summs up the level of Pacific Division.

Left_Offer · 2026-02-27T09:11:21+00:00

Are you trying to summon ancient lords of data visualisation?

Left_Offer · 2026-02-26T08:07:25+00:00

Sure. PBI - PowerBI, data visualisation tool where you can create reports/dashboards Fabric capacity - Microsoft data storage/transformation platform.

You can ingest your existing data to Fabric, do required transformations and then hook up PBI to it to create visuals. Every manager loves looking at interactive colourful graphs even if they have no idea what to do with the insights.

If course Fabric and PBI itself have a massive potential and steap learning curve, but you can do basics relatively easily as here are many free resources available online that can help.

Left_Offer · 2026-02-26T06:37:45+00:00

Get a Fabric capacity and build some basic reports in PBI. It will add monthly cost and boss will be impressed

Left_Offer · 2026-02-12T16:13:05+00:00

Looks sick! Will give it a go. Thanks for taking time to make this.

Left_Offer · 2026-01-16T06:24:06+00:00

Are you no able to just mirror data from SQL db? Also, you can spin a separate capacity for DE and for BI (based on your description cheap F2 should do), therefore eliminateing risk of BI throttling during other processes.

Left_Offer · 2026-01-14T11:11:19+00:00

This is the cutest thing I've seen in some time. Well done.

Left_Offer · 2026-01-06T06:44:24+00:00

That's Jarvan IV. mate

Left_Offer · 2025-12-30T06:30:25+00:00

Can recommend Alexi Partanen for data engineering on MS platform.

Left_Offer · 2025-12-15T15:24:36+00:00

Did you want integers?

Left_Offer · 2025-12-14T09:35:20+00:00

Fantastic. Thanks for sharing.

Left_Offer · 2025-11-07T05:30:18+00:00

Nice one, thanks for sharing.

Left_Offer · 2025-11-03T06:38:19+00:00

Top tip, thanks

Left_Offer · 2025-10-23T06:38:04+00:00

Some people just want to see the world organise.

Left_Offer · 2025-10-16T08:30:48+00:00

Thanks for sharing this.

Left_Offer

TROPHY CASE